Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

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?

Monday, August 20, 2012

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:

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

Wednesday, August 15, 2012

PI ProcessBook - Best Biopharm Practices 2

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.

Thursday, June 14, 2012

OSI PI DataLink and Excel 2007 Error


Recently, my Excel 2007 would launch with these annoying errors:
  • Compile error in hidden module: Main
  • Compile error in hidden module: modAddin OSI PI Tag Configurator error
  • Object library invalid or contains references to object definitions that could be found OSI PI Datalink error
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:
Did that work? It usually does.

If not, try this.

If you use OSI PI, check out: ZOOMS Search Engine