/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 vote222 views1 answer
Find days in month vba
VBA
0 vote248 views1 answer
Excel vba protect shapes
VBA
0 vote222 views1 answer
Vba pass named range to function
VBA
0 vote263 views1 answer
Winforms dark title bar
VBA
0 vote225 views1 answer
Vba line feed
VBA
0 vote233 views1 answer
Telephon call in vba
VBA
0 vote238 views1 answer
Windows Presentation Foundation dark title bar
VBA
1 vote234 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote245 views1 answer
VBA Sleep Snippet
VBA
0 vote238 views1 answer
Vba check if class implements interface
VBA