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

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