/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 vote196 views1 answer
Remove series name from legendvbnet
VBA
0 vote191 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
1 vote213 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
4 votes189 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
1 vote184 views1 answer
Excel vba last column in range
VBA
4 votes184 views1 answer
Excel vba check cell not empty
VBA
0 vote195 views1 answer
Excel vba set cell value to empty
VBA
-1 vote171 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote181 views1 answer
Vba code to select image in sheet
VBA
0 vote180 views1 answer
Vba code to open a file with login rights
VBA