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.

PI ProcessBook - Best Biopharm Practices 2

by Oliver Yu

The thing about visualizing process trends is that at some point, you're going to have to make a decision with it.  And when you make a decision with it in the cGMP environment, you're going to need someone to review the decision.  Perhaps this decision is big enough that you're going to need to document it.

Or perhaps, this decision needs a little CYA and you're going to have to present it to the plant management.  Whatever the case, there comes a time when you're going to have to take what you're seeing out of PI ProcessBook and put it in a Microsoft Word document or Powerpoint slide.

This is where the core philosophy of my ex-boss "Jesse B." comes in handy.  Jess is a big believer in one-stop or "few-stop" shopping for data.  You go to one or two places for data and spend the rest of your time analyzing.  OSIsoft PI server is the ideal stop for plant information.

The corollary to "One-Stop Shopping" is "No Additional Editing."  This means having the PI display formatted correctly where "correctly" means no additional work has to be done.

Face it, when you're facing a big decision and you've spent all your bandwidth on analyzing the data, the last thing you want to do is mouse around trying to get the background color right, or putting lipstick on the proverbial PI display pig.

Here are a few things to help you out:

• Use a white or transparent background for your PI ProcessBook displays.
  All Word documents and most Powerpoint slides have white backgrounds
• Use dark colors for primary tags
  The tags that need the most attention should have dark to contrast against the white background
• Use lighter colors for noisier tags
  Noisy tags like jacket temperature or controller output will do well with lighter colors

Have a look at this display and you can tell immediately that this can be copied and pasted directly into a memo with no additional editing:

You're shaving 5 to 10 minutes off every presentation you make.  Over the course of a week, we're easily talking an hour or two of your life you're never going to have to spend on making your memo look pretty.

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: