/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 vote159 views2 answers
How close excel through visual basic
VBA
0 vote173 views1 answer
Vb.net change cursor to wait
VBA
1 vote167 views1 answer
Vba date to unix timestamp
VBA
1 vote186 views1 answer
Excel vba first row in range
VBA
0 vote170 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote171 views1 answer
Convert unix to date vba
VBA
0 vote177 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote176 views1 answer
Vba html document reference
VBA
0 vote164 views1 answer
Excel vba remove formatting from cell
VBA
0 vote177 views2 answers
Open url from vba
VBA