/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 vote313 views1 answer
Vba shape transparent
VBA
1 vote299 views1 answer
Close form vba
VBA
-1 vote289 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
5 votes358 views1 answer
Excel vba low word from Long Integer
VBA
8 votes385 views1 answer
Excel vba determine number of elements in a 2D array
VBA
1 vote325 views1 answer
Excel vba last column in range
VBA
0 vote312 views1 answer
Change whcih control a user has selected vb
VBA
1 vote342 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
2 votes316 views1 answer
Vba split string
VBA
3 votes314 views2 answers
Excel "vba" match last value
VBA