/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 vote167 views1 answer
Hello world vb.net
VBA
3 votes181 views1 answer
Extract the nth word from a text string
VBA
5 votes191 views2 answers
Excel vba write to the windows registry
VBA
0 vote173 views1 answer
Vbscript remove spaces from string
VBA
0 vote193 views1 answer
Excel vba set cell value to empty
VBA
0 vote194 views1 answer
Excel vba DisplayAlerts
VBA
0 vote177 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
8 votes327 views1 answer
Vba make a short integer from two bytes
VBA
0 vote177 views1 answer
Vbscript check if string is empty
VBA
0 vote181 views1 answer
Excel R1C1 mode
VBA