/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 vote114 views1 answer
Vba get application version
VBA
1 vote73 views1 answer
Vba listindex select multiple items vba
VBA
0 vote123 views1 answer
Select case vba
VBA
0 vote121 views1 answer
Excel VBA web scraping
VBA
5 votes137 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote111 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote121 views1 answer
How to carry text to the next line in a label in vb.net
VBA
6 votes126 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote121 views1 answer
Vlookup columns not next to each other
VBA
0 vote110 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA