Microsoft KB Archive/159537

= XL97: Cannot Import/Export UserForms Between VBE and VB4.0 =

Article ID: 159537

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Visual Basic 4.0 Standard Edition

-



This article was previously published under Q159537



SYMPTOMS
In Microsoft Excel 97, if you try to import a Form that was created in Microsoft Visual Basic version 4.0, you will receive the following error message

The form class contained in is not supported in VBE.

The file can't be loaded.

and you are unable to import the Form.

In Microsoft Visual Basic version 4.0, if you try to import a UserForm that was created in Microsoft Excel 97, you will receive the following error message

Version number missing or invalid; Visual Basic 4.0 assumed.

followed by the error message

Errors during load. Refer to '\Myform.log' for details.

followed by the error message

'' could not be loaded.

and you are unable to import the UserForm.



CAUSE
You cannot import/export UserForms/Forms between Microsoft Excel 97 and Microsoft Visual Basic version 4.0.

This behavior is by design of the Microsoft products listed at the beginning of this article.



MORE INFORMATION
Even though you cannot import/export Microsoft Excel 97 UserForms with Microsoft Visual Basic 4.0, you can import/export UserForms between different Microsoft Excel 97 projects.

How to Export a UserForm From Your Project

 * 1) Activate the UserForm in your project.
 * 2) On the File menu, click Export File.
 * 3) In the Export File dialog box, select a destination folder for the .frm file, and type a name for your file in the File Name text box.
 * 4) Click Save.

How to Import a UserForm From Another Project

 * 1) In the Project Explorer window, select the Project that is going to import the UserForm you previously saved.
 * 2) On the File menu, click Import File.
 * 3) Locate and select the .frm file you want to import.
 * 4) Click Open.

