/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

2 votes212 views1 answer
Vba split string
VBA
31 votes262 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote231 views1 answer
Vbs exec hidden
VBA
0 vote230 views1 answer
Weekday vba
VBA
0 vote224 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote237 views2 answers
S yyyy-MM-dd em vb net
VBA
2 votes241 views2 answers
Excel vba if sunday or staurday
VBA
3 votes207 views1 answer
Vba make long from two shorts
VBA
0 vote222 views2 answers
Excel vba copy paste after last row
VBA
0 vote202 views1 answer
Vba find sub dictionary
VBA