/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 vote261 views1 answer
Vba remove the first character of string
VBA
0 vote224 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote251 views1 answer
Open file dialog in vb.net
VBA
0 vote235 views1 answer
Vba sheet visible
VBA
0 vote261 views1 answer
Excel vba DisplayAlerts
VBA
0 vote241 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote220 views1 answer
Excel vba concatenate range
VBA
0 vote253 views1 answer
Vba multiple optional arguments
VBA
0 vote263 views1 answer
Amd64 vs arm64 linux
VBA
0 vote261 views1 answer
Programmatically copy data from one workshet to another excel
VBA