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.
 
K

Ken

Garry
Turns out the problem was that the installation of Project 2010 (32
bit version) caused my Excel spreadsheets to lose some controls;
progress bar controls. The error messages all pointed me toward a
reference issue; but, once I deleted those controls the problem was
resolved. In troubleshooting, the missing Object error message was so
persistent I couldn't even display the tool box or do much of anything
to troubleshoot. I saw an internet posting somewhere else where
someone else had similar issue and it turned out to be calendar
controls for him.
Thanks again for your consideration of this post and your other
contributions to this group.
Ken
 

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