Wednesday, August 29, 2012

Compile Error in Hidden Module modAddin (Excel 2003, 2007)

You're here because you can't stand seeing this:

modAddin excel compile error in hidden module

anymore.  Your molars are ground flat and deleting the Forms folder didn't work for you.

You're in luck:  a guy who goes by GJBenzie wrote in and provided a solution that worked for my Windows Vista 32-bit and here it is:

Try This for Getting Rid of modAddin Errors

1. Go to Start > Run

2. Type cmd

Start Run CMD
3. At the prompt, type:

regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX

cmd unregister mscomctl.ocx 4. Hit Enter

mscomctl unregistered 5. Then type:

regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX cmd register mscomctl.ocx

6. Hit Enter

mscomctl registered

Did that work for you?



If you use OSI PI, check out: Want to never deal with this problem again?

30 comments:

Anonymous said...

Great! This worked for us. MS Office 2007 with PI ProcessBook Datalink add-in for Excel.

Thank you.

Unknown said...

This worked. No more alarm messages. Thanks

Unknown said...

The suggested action did the job, no more alarm messages. Thanks.

Anonymous said...

MS Office 2003, worked for OSI DataLink addin ... THANKS!

Anonymous said...

Those error messages were really annoying. This worked and they're gone now. Thank you! ~Andrew

Anonymous said...

thanks for sharing....
resolved the excel 07 w/ pi data link 3.1.6 issue.

Anonymous said...

As the September 10, 2012 commentor said: Great! This worked for me. Window XP, MS Office 2007 with PI ProcessBook Datalink add-in for Excel.

Anonymous said...

I had this problem with XP and Excel 2007 with PI ProcessBook Datalink add in. I had error messages both when I open and also when I closed Excel. This solved it all. Thanks a lot

Anonymous said...

cool!! Great!! i love you!!
thank you so much!

Anonymous said...

thank you so much! it was really usefull

Anonymous said...

Yes - I also have PI Datalink installed and this worked

TheCookieMonster said...

Thanks!

Anonymous said...

Got a reply:

DLLRegisterServer in c:\windows\system32\mscomctl.ocx failed. Return code was: 0x8002801c

Is this because i'm not an admin on my company computer?

Anonymous said...

Anonymous 2/15/13: You might need to run cmd as an administrator, as you guessed.

Go to Start > All Programs > Accessories

Then right-click on Command Prompt, and select "Run as administrator".

Follow the steps outlined above, and it should work. (I had the same issue as you did, and it worked for me.)

Anonymous said...

After the last bulk of patches from microsoft, this
procedure didn't work. It has worked every time before, but not this time...

Anonymous said...

With a x64 machine I found the mscomctl.ocx in the sysWOW64 system directory. Did a unreg - reg and that fixed it all... Thank you!

Anonymous said...

Just like the comment above, had to go to sysWOW64 for mscomctl.ocx. running windows 7 64-bit running PI Datalink. worked perfectly! Thanks!

Ivan said...

Thanks! This error was after installation of SharePoint 2010 on Win XP SP2 RUS. Excel with PI data Link and SMT was crashed. Thanks a lot!!!

Anonymous said...

Yep, worked for me. Using PI Datalink in Excel. Thank you

Anonymous said...

It did not work for me. Please help!

fighting for fun said...

FILE NOT FOUND PLEASE HELP ,ME

Anonymous said...

This solved it for me. Thanks!

Anonymous said...

Thanks, worked great for me (WinXP 32 + PI Datalink)

Anonymous said...

Thanks. This worked for me Windows 7, Office 2010.

Anonymous said...

thanks!

Anonymous said...

Muuuuuuuchas gracias,
El procedimiento me sirvió.
Windows XP + PI + Office 2007

Non-techie Talk said...

Didn't work for me. The first entry worked, but the second generated another error; and when I launch Excel, the error messages continue.

nontechietalk@gmail.com

Anonymous said...

This worked a charm!! Thanks a lot. I had to run the second command with an admin account though.

Windows 7, Excel 2010, PITagConf

Anonymous said...

Worked perfectly, thank you!

Unknown said...

I didnt work for me any new suggestion?