/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 vote197 views1 answer
Excel vba set cell value to empty
VBA
0 vote193 views1 answer
Vba code to select image in sheet
VBA
0 vote194 views1 answer
Excel web scraping
VBA
0 vote162 views1 answer
Excel protect cells with formulas
VBA
0 vote176 views1 answer
Vbs send keys
VBA
5 votes189 views1 answer
Excel vba right word from Long Integer
VBA
2 votes178 views1 answer
Excel vba date to string conversion
VBA
0 vote178 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote185 views2 answers
Excel vba number format file size
VBA
0 vote175 views1 answer
Internet explorer reference vba
VBA