Answers for "excel vba add adodb reference programmatically"

VBA
0

excel vba add reference programmatically

Sub Add_Reference()
    Application.VBE.ActiveVBProject.References.AddFromFile _ 
    	"C:WindowsSystem32scrrun.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
Posted by: Guest on January-31-2021

Code answers related to "VBA"

Browse Popular Code Answers by Language