#1
|
|||
|
|||
How do I know which libraries I need?
I have this *.xlsm file I made with Excel 2007, and it won't work in Excel 2010.
As I open the file, a pop-up is displayed: The object library is not valid or contains references to object definitions that cannot be found. (this is my translation from the pop-up in Italian, please forigve me if it is not 100% as in the English Excel) No macro works, not even the calendar. The same pop-up keeps displaying. How do I know which libraries I need to import in Excel 2010? In the VB editor, I checked under Tools > References both in Excel 2007 and Excel 2010 and the flagged ones are the same. |
#2
|
||||
|
||||
What libraries does the macro reference?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Here's what I have
I am attaching the libraries I get in Excel 2010.
In Excel 2007, they are the same, just any reference to Excel 14.0 should be read as Excel 12.0 |
#4
|
||||
|
||||
Usually, if any problem is to be encountered, it will be the reverse of what you're describing (ie a project compiled on Office 2010 won't run on Office 2007). I'd suggest unchecking the last three listed references, then re-adding them.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
||||
|
||||
I'm assuming these 2 different versions of Office are installed on two different boxes. Here are a few more things to check out in case Paul's suggestion doesn't resolve it:
|
#6
|
||||
|
||||
Quote:
Quote:
Quote:
Errors detected when saving [nameofmyfile].xlsm. It may be possible to save the file by removing or restoring some features. To execute the restoring options in a new file, click on Continue. To cancel saving, clic on Cancel. I clic on Continue, and then another pop-up displays, reading: There were some errors during saving. Minimal saving of file C:\Users\[username]\AppData\Roaming\Microsoft\Excel\XL17C8.xlsb Quote:
Module MSCOMCTL.OCX was loaded, but the DllRegisterServer call failed. Error code 0x8002801c. Is there any chance I can send the file in PM to some life-saver out there? I don't feel like publishing it on the board as it has some sensitive content. Thanks for your help. |
#7
|
||||
|
||||
Were you running as administrator when you tried to register it?
|
#8
|
|||
|
|||
Yes, I am an admin on this computer.
|
#9
|
||||
|
||||
I searched for that hex error on google and the only reasons people have cited for the error are either (1) they were trying to register it on 64-bit windows and the file was in the wrong folder or (2) they did not have admin rights.
Neither of these apply to you so, sorry, but I'm out of ideas. The only thing I can suggest is that you try registering it from command prompt, explicitly running as admin. |
#10
|
|||
|
|||
Quote:
I just have to re-do the calendar pop-up stuff and we're all set. In case you're curious, I have exported the calendar form that was causing the issue and I am attaching it to this thread. I cannot tell why or where the issue is, I am just thankful for being blessed and having saved my back. |
#11
|
||||
|
||||
Quote:
It'll be interesting to know if everything works when you re-create the calendar on the userform, but I'm not overly hopeful. |
#12
|
|||
|
|||
Quote:
Start>Run> REGSVR32 MSCOMCTL.OCX and then press CTRL+ALT+ENTER (instead of simply hitting Enter) An ordinary command prompt or Run box doesn't have the permissions needed to perform the registration of the ocx. [kudos go to http://www.gmayor.com/downloads.htm > MSCAL.ZIP] |
#13
|
||||
|
||||
Ah, great work! Hopefully the errors in your Excel project should disappear now.
Thanks for letting us know how you managed to get it registered! |
#14
|
|||
|
|||
Quote:
Thank you very much for your support! |
Thread Tools | |
Display Modes | |
|