/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 vote346 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote326 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote376 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote323 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote352 views1 answer
Vba array dimensions
VBA
0 vote339 views1 answer
Vbs expand env var
VBA
1 vote357 views1 answer
Export datagridview to excel vb.net
VBA
0 vote343 views1 answer
Excel vba hide gridlines
VBA
0 vote331 views1 answer
Vbs
VBA
12 votes460 views1 answer
Excel vba write string to text file
VBA