Visual basic error opening sreadsheet

[Andrewrx]

Never seen this before! CAN ANYONE HELP???

I have a spreadsheet, which is accessed by a number of people from different pc's, this file has a couple of simple macros for sorting data.

On one pc this file opens with an error message box.
---------------------------------------------
"Microsoft Visual Basic"
Class not registered
Looking for object with CLSID:{AC9F2F90-E877-11CE-9F68-00AA00574A4F
---------------------------------------------

The PC which has this error has just been completley re-formated having windows 98SE and Office 2000 Pro reinstalled.

Could this be something to do with my problem?

thanks
A.

 

[Andrew Poulsom]

In the VBE choose Tools, References. Compare the checked items with the machines on which the macro works.

It's probably something to do with limited installation.

 

[Ivan F Moala]

On 2002-10-16 04:39, Andrewrx wrote:
Never seen this before! CAN ANYONE HELP???

I have a spreadsheet, which is accessed by a number of people from different pc's, this file has a couple of simple macros for sorting data.

On one pc this file opens with an error message box.
---------------------------------------------
"Microsoft Visual Basic"
Class not registered
Looking for object with CLSID:{AC9F2F90-E877-11CE-9F68-00AA00574A4F
---------------------------------------------

The PC which has this error has just been completley re-formated having windows 98SE and Office 2000 Pro reinstalled.

Could this be something to do with my problem?

thanks
A.

Check your System Dir for the DLL
FM20.DLL = Microsoft Forms 2.1 FormPackage
If not present then Reinstall Office.

 

[Andrewrx]

Thanks for your feedback,

I have tried both these suggestions, but no joy

the VBE references are the same as other machines
&
the DLL file is installed

A.

 

[Andrew Poulsom]

Maybe the DLL is corrupted. You could try copying it from a working machine.

 

[Ivan F Moala]

Have you tried reregistering the control

I have an example @ my Site of how to register a control...

 

[Andrewrx]

Have not rectified the problem.

I will re-install Office at some point to see if this can sort the error.

Many thanks
A.

 

[Andrew Poulsom]

Maybe you have already done this, but see:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q182500

 

[Andrewrx]

yes that is a winner!!!

Have registered the dll file and all working 100%

Brilliant

thanx again
A.

 

[Andrew Poulsom]

To be fair, that's what Ivan suggested.