Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
object library problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
object library problem
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. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
object library problem
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 On Aug 6, 7:38*pm, GS wrote: 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. -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Word 12.0 Object Library | Excel Programming | |||
Object Library invalid or contains references to object defintions | Excel Programming | |||
Excel AddIn .dll problem: 'Can't find object or library' | Excel Programming | |||
Object Library problem | Excel Programming | |||
Problem with the Excel 10.0 Object Library | Excel Programming |