Ugh.
Recently, my Excel 2007 would launch with these annoying errors:
After boggling at these gems of clarity, any typical user simply stops using Excel (if possible).
But if Excel is a daily workhorse of productivity, the next path of least resistance is to disable the Add-Ins.
Still using Excel to store Cell Culture Data?
Of course, if access to tabular OSI PI data (DataLink) or bulk tag configuration (Tag Configurator), your only option is to fix this Excel 2007/OSI PI Add-In error.
If not, try this.
If you use OSI PI, check out:
Recently, my Excel 2007 would launch with these annoying errors:
- Compile error in hidden module: Main
- Compile error in hidden module: modAddin
- Object library invalid or contains references to object definitions that could be found
After boggling at these gems of clarity, any typical user simply stops using Excel (if possible).
But if Excel is a daily workhorse of productivity, the next path of least resistance is to disable the Add-Ins.
Still using Excel to store Cell Culture Data?
Of course, if access to tabular OSI PI data (DataLink) or bulk tag configuration (Tag Configurator), your only option is to fix this Excel 2007/OSI PI Add-In error.
How to fix
You simply need to delete the Forms directory:- For Windows XP:
C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Forms
- For Windows Vista, Windows 7:
C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Forms
If not, try this.
If you use OSI PI, check out:
12 comments:
that didn't help for me :(
Sorry to hear. Did you also Repair PI DataLink?
Excellent ! this fixed my problem
I have the PI ProcessBook Datalink add-in for Excel. I had this problem whenever I would open or close Excel. I found out that it was linked to a recent automatic update of "Microsoft Office 2003 Web Components". Go to add/remove programs, right click, and repair the web component installation.
yes and didn´t solve the problem
Hello all,
I have run into this error and tried the above suggestions to no avail. Below is what worked for me.
If on a 64-bit machine
Type the following:
regsvr32.exe /u C:\Windows\SysWOW64\MSCOMCTL.OCX
Press Enter.
Then type:
regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCX
If on a 32-bit machine
Type the following:
regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX
Press Enter.
Then type:
regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX
Hope it helps!
Thanks GJ, I'd had this problem before & got past it by deleting MSComctlLib.exd but this time it didn't work but using your solution fixed the problem for me.
Yup, me too. I put it in a post so people don't have to dig through comments to find this great solution. Lemme know if you need a linkback to you:
http://blog.zymergi.com/2012/08/compile-error-in-hidden-module-modaddin.html
Dear Sir,
We have same problem, when open Excel2007,
error messages from Microsoft Forms show as below.
Could not load an object because it is not available on this machine.
error messages from Microsoft Visual Basic show as below.
Compile error in hidden module: atProcessDataXL
I type as below.
regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCX
regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX
Restart PC, Open Excel2007 remain show error.
Help to verify.
It looks as though you are doing the register/unregister order in reverse.
1. regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX
un registers the ocx file
2. regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX
registers the file again
There should be no need to restart the machine.
it worked like a charm, thnx !
I tried this without success. First I typed in:
regsvr32.exe /u C:\Windows\SysWOW64\MSCOMCTL.OCX
and that seemed to work fine.
However when I typed in:
regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCX
I get the error message:
The module "C:\Windows\SysWOW64\MSCOMCTL.OCX" was loaded but the call to DllRegisterServer failed with error code 0x8002801c.
I can't seem to get around this.
Post a Comment