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

hi,
I had a similar problem. What I did was copied the code out and pasted it in
a module and workbook in the place it did not work. It worked after that.
Hope it works for you.

Thanks,

"PC" wrote:

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

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

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

Technically, I think you could put it anywhere provided it is registered
correctly.

I would have a look for it in System32, then System. If it's not in either,
then if System32 exists (all the more recent OSs), put it in there, else in
System.

Robin Hammond
www.enhanceddatasystems.com

"PC" wrote in message
...
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

Thanks Robin!

PC


"Robin Hammond" wrote in message
...
Technically, I think you could put it anywhere provided it is registered
correctly.

I would have a look for it in System32, then System. If it's not in
either,
then if System32 exists (all the more recent OSs), put it in there, else
in
System.

Robin Hammond
www.enhanceddatasystems.com

"PC" wrote in message
...
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