object library problem

K

Ken

I have a 2007 workbook that used to have a reference to the MS Project
12 Object library. I recently installed Project 2010 and now I get an
Object library invalid error whenever I open the file. I get the
error regardless of whether macros are enabled, and the error pops up
so much I can't close the file without using task manager. I do not
see any missing or broken references. I have deleted any code that
initiates MS Project. The file continues to work well on a computer
with only Project 2007; of course the export to Project code no longer
works, but, I can live with that. I jst need it to function on the
computer that has Project 2010 installed; without the reference to
Project.

I have deleted all references except
Visual Basic for Applications
Microsoft Excel 12.0 Object Library
Microsof Office 12.o Oject Library

I can create an run macros on this machine; when I open the file that
previously had a reference to Project 12 and has been "upgraded" to
Project 2010 is get overwhelmed with Object library errors. I don't
have any more ideas.

Any suggestions?

Thanks

Ken
 
G

GS

It happens that Ken formulated :
I have a 2007 workbook that used to have a reference to the MS Project
12 Object library. I recently installed Project 2010 and now I get an
Object library invalid error whenever I open the file. I get the
error regardless of whether macros are enabled, and the error pops up
so much I can't close the file without using task manager. I do not
see any missing or broken references. I have deleted any code that
initiates MS Project. The file continues to work well on a computer
with only Project 2007; of course the export to Project code no longer
works, but, I can live with that. I jst need it to function on the
computer that has Project 2010 installed; without the reference to
Project.

I have deleted all references except
Visual Basic for Applications
Microsoft Excel 12.0 Object Library
Microsof Office 12.o Oject Library

I can create an run macros on this machine; when I open the file that
previously had a reference to Project 12 and has been "upgraded" to
Project 2010 is get overwhelmed with Object library errors. I don't
have any more ideas.

Any suggestions?

Thanks

Ken

Ken, ..just some ideas:

I'm curious what version of Project 2010 you're using. (ie: x64 or x32)
Normally, x32 code won't work in x64 apps.

Perhaps the code needs to be 'version aware'. That means if the newer
version has replaced previous version functionality then you may have
to accomodate that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top