/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

1 vote215 views2 answers
Vba function return array
VBA
0 vote226 views1 answer
Vba remove last vbcrlf
VBA
4 votes212 views1 answer
Excel formula for last non-empty cell in a column
VBA
3 votes219 views1 answer
Excel vba read registry key value
VBA
0 vote288 views1 answer
Vba is integer
VBA
0 vote218 views1 answer
WGET FTP
VBA
0 vote227 views1 answer
Change form background image vb
VBA
3 votes236 views1 answer
Vba post request json
VBA
0 vote222 views1 answer
Loop through each cell in dgv vbnet
VBA
1 vote235 views1 answer
Extract the second word in a text in excel
VBA