/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 vote242 views1 answer
Vba copy file
VBA
0 vote268 views1 answer
Vba registry settings
VBA
0 vote246 views1 answer
Vba check if class implements interface
VBA
1 vote239 views1 answer
Excel vba make cell visible
VBA
0 vote233 views1 answer
Vba code to select image in sheet
VBA
0 vote259 views1 answer
Remove last 8 characters from string vb
VBA
0 vote287 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote233 views1 answer
Excel vba formatconditions range
VBA
5 votes250 views1 answer
Excel vba left word from Long Integer
VBA
0 vote237 views1 answer
Excel R1C1 mode
VBA