/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 vote332 views1 answer
Excel vba cell on change
VBA
0 vote326 views1 answer
Vba full date format
VBA
0 vote408 views1 answer
Excel vba delete columns in range
VBA
1 vote324 views1 answer
Add a index column power bi
VBA
0 vote312 views1 answer
Do until vb.net
VBA
0 vote331 views1 answer
String contins in vba
VBA
0 vote322 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote318 views1 answer
Vba word open document read only
VBA
0 vote328 views1 answer
Vba simple quote
VBA
0 vote332 views1 answer
Freeze panes vba
VBA