[Blog Map] This blog is inactive. New blog: EricWhite.com/blog
After installing security advisory 960715 and opening a workbook with one of Visual Basic 6 ActiveX controls embedded in the workbook you receive an error:
“Object library invalid or contains references to object definitions that could not be found” or “Element not found.”
For more information, see this post on the Visual Studio Office Developer Team’s blog. We want to get this message out to the most people possible.
I am getting multiple errors on Excel 2010. My OS is Win7 and Office was upgraded from 2007 to 2010 32bit:
Microsoft Visual Basic for Applications: Complie error in hidden module: Main. This error commonly occurs when code is incompatible with the version, platform, or architecture of this applicaton. Click "Help" for information on how to correct this error.
Microsoft Visual Basic for Applications: Object library invalid or contains references to object definitions that could not be found.
(on closing Excel 2010 only) Microsoft Visual Basic for Applications: Compile error in hidden module: mod Addin. This error commonly occures when code is incompatible with the version, platform, or architecture of this applications. Click "Help" for information on how to correct this error.
Sounds like an Add-in is causing the issue. I would troubleshoot which one by clicking the File tab, clicking Options, clicking Add-Ins, selecting COM Add-Ins under Manage, and then clicking Go... Uncheck all the Add-ins that load on Startup and then click OK. Close Excel 2010. Then, go back into the same COM Add-Ins dialog and check one Add-in and then click OK. Restart Excel. If you get the error message, then it's that Add-In that's causing the problem.
1. Open the command prompt.
2. Navigate Document and Settings
3. C:\Documents and Settings>del /S /A:H /A:-H *.EXD (and press enter key)
Abbas Mohamed - thank you the excellent advise on solving the above problem. I shall save this to my support information file.
This didn't solve my issue.I'm still receiving this error!
Abbas...solved my problem with Execl 2010 on Windows XP Professional...thank you.
Thanks Abbas for the perfect solution.
The solution proposed by Abbas Mohamed
Does not worked for me.
Each time the files are deleted. Each they are showing again when I try to open my Excel file.
Any other idea ?
Excellent Abbas Mohamed.. thanks for your help.... now itz not error out...
Thanks Abbas. The problem is resovled.
There is no c:\documents and settings for windows 7...
Thanks Stephen D. Oliver
I had this error with Excel and it WAS the Add In I had installed, I could not repair it so i had to remove the add-in and problem has been resolved
One way to work around this is to explicitly add the reference to the controls:
1. Open the .xls file in question and click OK after getting the error mentioned above.
2. Open the Visual Basic Editor (Alt+F11)
3. Open (if they are not already open) one of the modules or code behind forms
4. Click on Tools / References...
5. In the pop-up window click on Browse...
6. Navigate to [Your Windows Directory]\System32 (it may open by default)
7. Type MSCOMCTL.OCX (you'll see it in the auto-select options before you finish typing)
8. Click Open and the reference will appear as Microsoft Windows Common Controls 6.0 (SP6)
9. Click on Debug\Compile VBAProject to verify that the problem is solved
10. Save the file.
This worked for me. Thanks.
May I know what exactly you are trying to do with the command.
Worked for me