/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 vote203 views1 answer
Vba excel do not recalculate before save
VBA
6 votes170 views1 answer
Excel vba get the path of current workbook
VBA
0 vote160 views1 answer
Sort dictionary by key vba
VBA
5 votes179 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote164 views1 answer
String contins in vba
VBA
0 vote148 views1 answer
Excel vba hide columns
VBA
0 vote152 views1 answer
Vb check if row has column
VBA
1 vote149 views1 answer
What does vbs stand for
VBA
0 vote143 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote151 views2 answers
Excel vba close without saving
VBA