VBA: ErrMsg: "Class Not Registered" Inserting UserForm

ID: Q182500

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft PowerPoint 97 For Windows
Microsoft Word 97 for Windows
Microsoft Visual Basic for Applications version 5.0

SYMPTOMS

When you attempt to insert a UserForm while you are in the Microsoft Visual Basic Editor in one the products listed at the beginning of this article, or when you attempt to open a document that contains a UserForm, you may receive the following error message:

Class not registered.
Looking for object with CLSID:{AC9F2F90-E877-11CE-9F68-00AA00574A4F}

or

Class not registered.
Looking for object with CLSID:{C62A69F0-16DC-11CE-9E98-00AA00574A4F}

When you click Help, the following message appears:

The Help topic does not exist. Contact your application vendor for an updated Help file (129)

The dialog box is dismissed when you click OK.

The error may also appear when you attempt to save a Microsoft Excel 97 document as an Hypertext Markup Language (HTML) document by clicking Save As HTML on the File menu. When you click OK, a dialog box with the following message appears:

400

CAUSE

This problem may be caused by a missing or incorrect Microsoft Windows registry entry for the Dynamic Link Library Fm20.dll. The proper registration of this file is required when you work with UserForms and form controls in Microsoft Excel 97.

RESOLUTION

To resolve this problem, register Fm20.dll. You must have Regsvr32.exe to register Fm20.dll. If you do not have Regsvr32.exe you can download the file. For additional information, please see the following article in the Microsoft Knowledge Base:

Q161983 Regsv32a.exe Available in Download Center

Registering Fm20.dll

To Register Fm20.dll, follow these steps:

Use Microsoft Windows Explorer to locate the Fm20.dll file in the Windows\System folder or in the Winnt\system32 folder (under Microsoft Windows NT).

If the file is not present, copy it from the OS\System folder on the Microsoft Office 97 compact disc to the appropriate location.

Close all open programs.

Click Start on the Windows taskbar, click Run, and then type the following:
Regsvr32.exe fm20.dll

Click OK. The following message should appear:
DllRegisterServer in c:\windows\system\fm20.dll succeeded.

The file Fm20.dll should be registered correctly.

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: XL97

Keywords : kberrmsg kbprg
Version : WINDOWS:5.0,97
Platform : WINDOWS
Issue type : kbhowto