Answers for "excel where is vba code"

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 "excel where is vba code"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#