/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

2 votes370 views1 answer
Vba file from path
VBA
1 vote410 views1 answer
Perform http request in vb.net
VBA
0 vote340 views1 answer
Excel vba center userform
VBA
0 vote502 views1 answer
Vba array of integers
VBA
0 vote352 views1 answer
Vbscript for loop
VBA
0 vote343 views1 answer
Excel vba automatic calculation
VBA
0 vote349 views1 answer
Excel vba delete folder
VBA
1 vote354 views1 answer
Vbs run
VBA
0 vote353 views1 answer
Excel vba cell on change
VBA
5 votes930 views1 answer
Vlookup vba
VBA