/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 vote303 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote308 views1 answer
Excel vba protect sheet
VBA
0 vote273 views2 answers
Excel vba close without saving
VBA
5 votes818 views1 answer
Vlookup vba
VBA
-1 vote297 views1 answer
Vba code to add new column in table
VBA
1 vote302 views2 answers
Get all column names from excel vba
VBA
0 vote298 views1 answer
Vba test optional argument
VBA
0 vote305 views1 answer
Vba parameter adodb null value
VBA
1 vote339 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote290 views1 answer
Convert number to minutes in vba
VBA