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.

What libraries does the macro reference?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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

Attached Images

Immagine.png (45.5 KB, 18 views)

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]

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:

• is it 64-bit Office 2010? If yes then the windows common controls won't work because MSCOMCTL.OCX is a 32-bit binary. There isn't a 64-bit version of MSCOMCTL.OCX available so you'll need to re-write your project without using those controls.
• the refedit control often causes problems. If you're not actually using a refedit control in your project then remove it from the references.
• if it is 32-bit Office 2010 then try reregistering the windows common controls library by going to Start>Run> REGSVR32 MSCOMCTL.OCX

Correct. My office computer was upgraded to Office 2010 32-bit on Win7 32-bit. Previously I was using Office 2007 32-bit on Win7 32-bit (I created this Workbook with that configuration). They are upgrading all of the company computers, thus I need to solve this issue. One year worth of work/programming, and it won't work in 2010?!


No, it's 32-bit.

Whatever I uncheck from my references, then I am unable to save the workbook. A pop-up displays and reads:

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

Done, but a pop-up displays, and it reads:

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.

Were you running as administrator when you tried to register it?

Yes, I am an admin on this computer.

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.

But you gave me one brilliant idea: I removed the pop-up calendar and now it is all working.
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.

Attached Files

Calendario.zip (48.7 KB, 9 views)

The calendar control is part of the MSCOMCTL.OCX file. The issue is that it isn't registered (what we were trying to do with REGSVR32).
It'll be interesting to know if everything works when you re-create the calendar on the userform, but I'm not overly hopeful.

It can be registered if you do this:

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]

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!

Unfortunately it stays, but I am working on adding a new calendar in Office 2010 which is hopefully working also in 2007. I have to research on the Calendars available and compatible with 2007 and 2010 (Microsoft Date & Picker was removed and there is no default control for calendar in 2010).

Thank you very much for your support!