/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

0 vote226 views1 answer
Windows Presentation Foundation dark title bar
VBA
8 votes234 views1 answer
Run command pormpt in background windows
VBA
0 vote238 views1 answer
Weekday vba
VBA
0 vote229 views1 answer
Vb get ip address
VBA
1 vote228 views1 answer
Vbs run
VBA
0 vote236 views1 answer
Vba sort the data Z to A
VBA
8 votes271 views1 answer
Vba make a short integer from two bytes
VBA
0 vote224 views1 answer
Search combobox items vb.net
VBA
8 votes282 views1 answer
Excel vba make word
VBA
1 vote221 views1 answer
Excel vba unload userform
VBA