/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

1 vote358 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote364 views1 answer
Internet explorer reference vba
VBA
0 vote341 views1 answer
Excel vba populate array with cell values
VBA
0 vote390 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote365 views1 answer
Vb.net change cursor to wait
VBA
0 vote313 views1 answer
Excel vba linter
VBA
5 votes389 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote400 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote348 views1 answer
Excel vba extract year
VBA
5 votes409 views1 answer
Excel-vba get integer high byte
VBA