Thanks Robin. That's the detail I was looking for .

Question:

You indicate that I should use the System32 folder. On my computer the
FM20.dll is in the System folder. Is that a "typo" or is the location
dependent on the operating system, or does it even matter? (I don't know
much at all about dll's)

Thanks again

PC

"Robin Hammond" wrote in message
...
PC,

You need to make sure that FM20.dll is installed and registered on the
target machine. I've never gone that route, but on installation of Excel
there are obviously some configuration options that don't include the
file.

An installation package such as Visual Studio Installer would handle this
for you, but if this is a one off

1. put FM20.dll in the system32 folder on the target machine
2. Goto Start, Run, and enter this to register the dll
regsvr32 "C:\Windows\System32\FM20.dll"

Robin Hammond
www.enhanceddatasystems.com

"PC" wrote in message
...
I developed an applicaiton in VBA on my computer. However when I test it
on
some machines it works and others it doesn't. The problem is a missing
reference to the "Microsoft Forms 2.0 Object Library."

Some background,

My computer is running Office 2000 Win 98 (works fine)
The wife's computer is running Office 2003 & Win XP Pro (Works fine)

Tried it at work (Office 2000 Win 98) and it didnt' work.
Sent to a few friends, not sure of their systems (though I'm guessing a
later version of Office and Windows than I have and it didnt' work.

Is there any way to correct this.

Possibly that would be:
Somehow sending the library with the workbook
Changing the reference on my computer.
Or some other alternative.

Thanks in advance.

PC