/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 vote125 views1 answer
Type excel.application is not defined vb
VBA
1 vote137 views1 answer
Excel vba array remove first
VBA
0 vote137 views1 answer
.net dark title bar
VBA
1 vote118 views1 answer
Vba compile error object required
VBA
0 vote140 views2 answers
Open url from vba
VBA
0 vote138 views1 answer
Vba horizontalalignment
VBA
0 vote123 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote124 views1 answer
Excel vba ternary
VBA
1 vote126 views1 answer
Excel vba make cell visible
VBA
0 vote130 views1 answer
Vba string start with
VBA