/VBA/Excel vba add reference programmatically

Excel vba add reference programmatically

Sub Add_Reference()
    Application.VBE.ActiveVBProject.References.AddFromFile _ 
    	"C:\Windows\System32\scrrun.dll"
End Sub

Sub Remove_Reference()
    Dim oReference As Object
    Set oReference = Application.VBE.ActiveVBProject.References.Item("Scripting")
    Application.VBE.ActiveVBProject.References.Remove oReference
End Sub

Similar codes

1 vote146 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote130 views1 answer
VBA Sleep Snippet
VBA
3 votes116 views1 answer
Vba not equal
VBA
0 vote135 views1 answer
Default host vbox address
VBA
0 vote136 views1 answer
Vba copy file
VBA
0 vote133 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote126 views1 answer
Vba code to open a file with login rights
VBA
3 votes125 views1 answer
Vba request json
VBA
0 vote130 views1 answer
Rotate image by any angle vb.net
VBA
0 vote117 views1 answer
Vbnet chart make 0 gridline line different color
VBA