/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

3 votes328 views1 answer
Excel vba get the workbook full filename with path
VBA
7 votes347 views1 answer
Excerl vba array to range
VBA
1 vote287 views1 answer
Excel vba hide zero values
VBA
0 vote311 views1 answer
VB Error Code BC30201
VBA
4 votes299 views2 answers
Vba array length
VBA
0 vote300 views1 answer
Vbs
VBA
0 vote331 views1 answer
Vba registry settings
VBA
0 vote311 views1 answer
Vbnet check if string is only numbers
VBA
0 vote310 views1 answer
Vba code to open a file with login rights
VBA
1 vote307 views1 answer
Excel vba first row in range
VBA