/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

4 votes159 views1 answer
Excel vba how to reset usedrange
VBA
0 vote165 views1 answer
Move bindingnavigator vb
VBA
0 vote175 views1 answer
Tester si une case est vide vba
VBA
0 vote166 views1 answer
Vba find sub dictionary
VBA
0 vote161 views1 answer
Xlbycolumns is not declared
VBA
0 vote163 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote173 views1 answer
Vbscript check if string contains
VBA
0 vote106 views1 answer
How to sort datagridview in vb.net
VBA
0 vote165 views1 answer
VBA Loop to range
VBA
1 vote159 views1 answer
Excel vba to lower case
VBA