/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 vote146 views1 answer
Vbs
VBA
0 vote160 views1 answer
Vba min
VBA
1 vote157 views1 answer
Excel vba autofit
VBA
0 vote147 views1 answer
Make your computer talk vbscript
VBA
0 vote155 views1 answer
Programmatically copy data from one workshet to another excel
VBA
5 votes161 views1 answer
Xlvba double quotes in string literal
VBA
3 votes154 views1 answer
Vba http request json
VBA
0 vote124 views1 answer
How to self delete a vbscript file
VBA
0 vote151 views1 answer
Excel vba urlmon
VBA
0 vote152 views1 answer
Filesystemobject vba reference
VBA