/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 vote262 views1 answer
Get month number from month name vbnet
VBA
0 vote270 views1 answer
How to enter Vbox manage commands
VBA
0 vote246 views1 answer
Vbnet round to nearnest thousand
VBA
1 vote228 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
1 vote238 views1 answer
If inputbox cancel vba
VBA
2 votes172 views2 answers
Vba exit loop
VBA
0 vote230 views1 answer
Excel vba hide columns
VBA
-1 vote256 views1 answer
Vba sendkeys
VBA
0 vote230 views1 answer
Vba horizontalalignment
VBA
0 vote206 views1 answer
Vba code to open a file with login rights
VBA