Microsoft Excel 12.0 Object Library reference upload

chamdan · #1 04-20-2014, 10:29 PM

Hi,

Does anyone out there know how to add the reference library listed above using vba from inside ms project and remove the before closing.

I tried the following but seems not to work:

HTML Code:

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

HTML Code:

Public Sub removeRefToOffice()
  Dim ref As Object
  On Error Resume Next
  Set ref = Application.VBE.ActiveVBProject.References("C:\Program Files\Microsoft Office\Office12\MSO12.DLL")
  Application.VBE.ActiveVBProject.References.Remove ref
End Sub

I look forward to hearing from someone.

Regards,

Chuck

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

JulieS · #3 04-21-2014, 06:30 AM

Glad you were able to solve it and thanks very much for posting the answer!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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