/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

3 votes204 views1 answer
Vba double quote
VBA
0 vote252 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote214 views1 answer
Vba open report
VBA
0 vote212 views1 answer
Vba sheet hide unhide
VBA
0 vote197 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote202 views1 answer
Search in richtextbox vb.net
VBA
0 vote166 views1 answer
Vba select file in folder
VBA
0 vote194 views1 answer
Internet explorer reference vba
VBA
0 vote198 views1 answer
Reset border color textbox vba
VBA
0 vote191 views1 answer
Change form background image vb
VBA