/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

20 votes512 views1 answer
Excel vba factorial
VBA
0 vote234 views1 answer
Excel vba round to whole number
VBA
0 vote206 views1 answer
Vba compare strings
VBA
1 vote214 views1 answer
Excel vba array remove first
VBA
0 vote200 views1 answer
Vba get text file content
VBA
0 vote228 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote226 views1 answer
Vba random number
VBA
5 votes147 views1 answer
Vlookup vba
VBA
5 votes222 views1 answer
Xlvba double quotes in string literal
VBA
0 vote200 views1 answer
Test if form is open vb
VBA