Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2012, 02:45 AM
Isadora Isadora is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2007
Novice
How do I know which libraries I need?
 
Join Date: Mar 2012
Location: Milan, Italy
Posts: 18
Isadora is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 07-11-2012, 03:45 AM
macropod's Avatar
macropod macropod is online now How do I know which libraries I need? Windows 7 64bit How do I know which libraries I need? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,835
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

What libraries does the macro reference?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-11-2012, 04:36 AM
Isadora Isadora is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2007
Novice
How do I know which libraries I need?
 
Join Date: Mar 2012
Location: Milan, Italy
Posts: 18
Isadora is on a distinguished road
Default 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
Attached Images
File Type: png Immagine.png (45.5 KB, 16 views)
Reply With Quote
  #4  
Old 07-11-2012, 04:42 PM
macropod's Avatar
macropod macropod is online now How do I know which libraries I need? Windows 7 64bit How do I know which libraries I need? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,835
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #5  
Old 07-12-2012, 02:04 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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
Reply With Quote
  #6  
Old 07-13-2012, 02:04 AM
Isadora Isadora is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2010 32bit
Novice
How do I know which libraries I need?
 
Join Date: Mar 2012
Location: Milan, Italy
Posts: 18
Isadora is on a distinguished road
Default

Quote:
Originally Posted by Colin Legg View Post
I'm assuming these 2 different versions of Office are installed on two different boxes.
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?!


Quote:
Originally Posted by Colin Legg View Post
Here are a few more things to check out in case Paul's suggestion doesn't resolve it:
  • is it 64-bit Office 2010?
No, it's 32-bit.

Quote:
Originally Posted by Colin Legg View Post
  • the refedit control often causes problems. If you're not actually using a refedit control in your project then remove it from the references.
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

Quote:
Originally Posted by Colin Legg View Post
  • if it is 32-bit Office 2010 then try reregistering the windows common controls library by going to Start>Run> REGSVR32 MSCOMCTL.OCX
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.
Reply With Quote
  #7  
Old 07-13-2012, 02:20 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Were you running as administrator when you tried to register it?
Reply With Quote
  #8  
Old 07-13-2012, 02:25 AM
Isadora Isadora is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2010 32bit
Novice
How do I know which libraries I need?
 
Join Date: Mar 2012
Location: Milan, Italy
Posts: 18
Isadora is on a distinguished road
Default

Quote:
Originally Posted by Colin Legg View Post
Were you running as administrator when you tried to register it?
Yes, I am an admin on this computer.
Reply With Quote
  #9  
Old 07-13-2012, 02:36 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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.
Reply With Quote
  #10  
Old 07-13-2012, 02:47 AM
Isadora Isadora is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2010 32bit
Novice
How do I know which libraries I need?
 
Join Date: Mar 2012
Location: Milan, Italy
Posts: 18
Isadora is on a distinguished road
Default

Quote:
Originally Posted by Colin Legg View Post
I
Neither of these apply to you so, sorry, but I'm out of ideas.
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
File Type: zip Calendario.zip (48.7 KB, 7 views)
Reply With Quote
  #11  
Old 07-13-2012, 02:52 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Quote:
I cannot tell why or where the issue is,
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.
Reply With Quote
  #12  
Old 07-13-2012, 03:18 AM
Isadora Isadora is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2010 32bit
Novice
How do I know which libraries I need?
 
Join Date: Mar 2012
Location: Milan, Italy
Posts: 18
Isadora is on a distinguished road
Default

Quote:
Originally Posted by Colin Legg View Post
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 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]
Reply With Quote
  #13  
Old 07-13-2012, 03:21 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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!
Reply With Quote
  #14  
Old 07-13-2012, 03:25 AM
Isadora Isadora is offline How do I know which libraries I need? Windows 7 32bit How do I know which libraries I need? Office 2010 32bit
Novice
How do I know which libraries I need?
 
Join Date: Mar 2012
Location: Milan, Italy
Posts: 18
Isadora is on a distinguished road
Default

Quote:
Originally Posted by Colin Legg View Post
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!
Reply With Quote
Reply

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 10:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft