Microsoft Office Forums - View Single Post - [Solved] Microsoft Excel 12.0 Object Library reference upload

chamdan · 04-21-2014, 05:29 AM

I have finally resolved this issue of uploading programmatically the reference to Excel 12.0 Object library from ms project vba.
Here below is the solution:
Call the first macro from inside the Open_Event and one from the before_Close_Event.

First macro:

HTML Code:

Public Sub addRefToOffice()
  On Error Resume Next
  Application.VBE.ActiveVBProject.References.AddFromFile "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE"
End Sub

Second macro:

HTML Code:

Public Sub removeRefToOffice()
  Dim ref As Object
  On Error Resume Next
  Set ref = Application.VBE.ActiveVBProject.References("Excel")
  Application.VBE.ActiveVBProject.References.Remove ref
End Sub

Chuck