/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 vote185 views1 answer
Vba get application version
VBA
0 vote183 views1 answer
Vba add month to date
VBA
0 vote173 views1 answer
How to set location and size of new from vb
VBA
31 votes421 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote182 views1 answer
VB get external IP address
VBA
0 vote197 views1 answer
Vba timestamp -- milliseconds
VBA
1 vote138 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote178 views1 answer
Vba len variant
VBA
0 vote183 views1 answer
Vba open report
VBA
1 vote185 views1 answer
Vba refresh pivot table
VBA