/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 vote290 views1 answer
Vbscript for loop
VBA
0 vote274 views1 answer
Vba argument is set
VBA
0 vote246 views1 answer
Excel vba linter
VBA
1 vote276 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
6 votes321 views1 answer
Excel vba get the path of current workbook
VBA
0 vote285 views1 answer
Thread sleep vb
VBA
1 vote283 views1 answer
Vba delete file
VBA
0 vote313 views1 answer
Sort dictionary by key vba
VBA
-1 vote314 views1 answer
Code for reading letters only in vb 6
VBA
0 vote280 views1 answer
Vba verticalalignment
VBA