/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

1 vote133 views1 answer
Add a index column power bi
VBA
0 vote140 views1 answer
Vba get application version
VBA
1 vote139 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
1 vote145 views1 answer
Vba login website
VBA
0 vote146 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote143 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote137 views1 answer
Vbscript abs
VBA
1 vote134 views1 answer
If inputbox cancel vba
VBA
0 vote145 views1 answer
Programmatically copy data from one workshet to another excel
VBA
4 votes139 views2 answers
Vba create folder if not exist
VBA