/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 vote149 views1 answer
Excel vba scroll to cell
VBA
0 vote147 views1 answer
Vba border weight
VBA
5 votes169 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote145 views1 answer
Vba createparameter null
VBA
0 vote157 views1 answer
Vba integer to double
VBA
0 vote155 views1 answer
Excel vba calculate
VBA
0 vote168 views1 answer
Excel vba protect scenarios
VBA
0 vote163 views1 answer
Vba copy file
VBA
8 votes232 views1 answer
Excel vba determine number of elements in a 2D array
VBA
5 votes170 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA