VBA: ErrMsg: "Class Not Registered" Inserting UserForm

ID: Q182500

The information in this article applies to:

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: 

   ARTICLE-ID: Q161983
   TITLE     : ACC: Regsv32a.exe Available on MSL

Registering Fm20.dll

To Register Fm20.dll, follow these steps:

1. 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.
2. Close all open programs.

3. Click Start on the Windows taskbar, click Run, and then type the 

   following:

      Regsvr32.exe fm20.dll
4. 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

Last Reviewed: April 5, 1999