/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 vote165 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote199 views1 answer
Vbnet check if string is only numbers
VBA
0 vote154 views1 answer
Excel vba concatenate range
VBA
27 votes303 views2 answers
Vba check if file exists
VBA
-1 vote186 views1 answer
Code for reading letters only in vb 6
VBA
0 vote159 views1 answer
Type excel.application is not defined vb
VBA
1 vote165 views1 answer
Excel vba get column name from number
VBA
0 vote166 views1 answer
Vba array of integers
VBA
3 votes175 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote169 views1 answer
Vb test if reference is null
VBA