/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 vote175 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote162 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote166 views2 answers
Delete all controls from list of control vb.net
VBA
5 votes485 views1 answer
Vlookup vba
VBA
0 vote170 views1 answer
Vba like with wildcard
VBA
0 vote163 views1 answer
Excel vba existence of a file
VBA
0 vote150 views1 answer
Excel autofilter vba
VBA
2 votes169 views2 answers
Excel vba copy values range to another range
VBA
0 vote175 views1 answer
Afficher un message d'erreur vba
VBA
1 vote178 views1 answer
Add a index column power bi
VBA