Microsoft Excel 12.0 Object Library reference upload

chamdan · #2 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
microsoft office upload center msosync.exe	q_auth6	Office	5	11-26-2013 02:49 PM
Excel VBA: How to add a reference to Microsoft Word Object Library?	tinfanide	Excel Programming	7	12-12-2011 05:21 AM
option Paste special...as 'Microsoft Excel Chart Object' NOT available	Intruder	PowerPoint	0	12-24-2010 06:28 AM
Problem: object library invalid or contains references to object definitions	aligahk06	Office	0	08-19-2010 12:29 PM
Access Object library 10	Gyto	Office	0	10-09-2008 09:04 AM