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

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



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


3. At the prompt, type:

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

4. Hit Enter

5. Then type:

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

6. Hit Enter



Did that work for you?



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

PI DataLink: Cannot Insert Trend

There's this feature in PI DataLink where you can insert a PI Trend:




It's a weird feature.  As in... if you wanted to see a trend, why not use PI ProcessBook?

See the PI ProcessBook Best Practices For BioPharma.

Whatever the case, if you click that link and nothing happens, then you have a problem with your PI DataLink.

It's a symptom whose disease is solved by deleting either of these two folders in order to fix the problem:

• For Windows XP:

  C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Forms

• For Windows Vista, Windows 7:

  C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Forms

It's actually the same exact root cause as those Compile error in hidden module: modAddin errors.

OSI PI DataLink and Excel 2007 Error

by Oliver Yu

Ugh.

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

Useful error messages, huh?

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

Did that work? It usually does.

If not, try this.

If you use OSI PI, check out: