/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 vote207 views1 answer
Excel text to columns line break
VBA
4 votes214 views2 answers
Excel vba last column with data
VBA
4 votes216 views1 answer
Excel vba how to reset usedrange
VBA
20 votes496 views1 answer
Excel vba recursive example factorial function
VBA
0 vote199 views1 answer
Vba find last column in a row with data
VBA
0 vote238 views1 answer
Vba dictionary length
VBA
0 vote206 views1 answer
Vba get relative cell address
VBA
0 vote217 views1 answer
Vba min
VBA
0 vote202 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote208 views1 answer
Vbs send keys
VBA