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