XL97: Converting Microsoft Excel 5.0 or 7.0 Dialogs to Excel 97

• Microsoft Excel 97 for Windows

SUMMARY

You can download a Microsoft Excel 97 add-in to convert a Microsoft Excel 5.0 or 7.0 dialog sheet to a Microsoft Excel 97 UserForm. The Dialog Converter for Microsoft Excel 97 automatically converts a dialog sheet to a UserForm. However, it does not attach any Microsoft Visual Basic for Applications programming code to the new UserForms.

MORE INFORMATION

Obtaining the Dialog Converter

You can download this add-in file from the following Web address:

   http://www.microsoft.com/ExcelDev/e-free.htm

   http://www.microsoft.com/

Finding Information About the Dialog Converter

Although Microsoft makes these macros and add-ins available, contact the vendor if you need assistance or more information. For more information about this product, contact Baarns Consulting Group, Inc. at the following Web address:

   http://www.baarns.com/devonly/

Using the Dialog Converter

The Dialog Converter simplifies the task of converting a Microsoft Excel 5.0 or 7.0 dialog sheet to a Microsoft Excel 97 UserForm. The conversion process creates the UserForm in the existing workbook and retains the Microsoft Excel 5.0 or 7.0 dialog sheet.

NOTE: To use this add-in file, you must have Microsoft Excel 97.

When you use the add-in to convert a dialog sheet to a UserForm, follow these steps:

1. To ensure that the Dialog Converter add-in is selected in the Add-Ins dialog box, click Add-Ins on the Tools menu, click to select the Dialog Converter 97 check box, and then click OK.

2. Open the Microsoft Excel 5.0 or 7.0 file that contains the dialog sheet that you want to convert.

   The add-in converts one or more of the dialog sheets in a file.

3. To start the add-in in Microsoft Excel 97, click Convert Dialogs on the Tools menu.

4. Click the Converter tab to select the dialog sheet to convert.

   Click the Position tab to change the top and left properties of the controls on the dialog and frame.

   Click the Options tab to change how the add-in converts the dialog. For example, you can click "Backup original project before making modifications," "Name new controls based on previous control names," and "Use standard control dimensions where possible."

   Click the About tab to find information about the add-in.

5. Click OK to generate a UserForm that is based on the dialog sheet you selected in the Converter tab.

6. When the "The conversion was successfully completed" message appears, Click OK. Please save the file, close, and then reopen Excel before you continue to work.

7. To save the workbook, click Save on the File menu.

8. To quit Microsoft Excel, click Exit on the File menu.

The products mentioned here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

If you have any problems when you use this add-in, contact the vendor for more information.

REFERENCES

For more information about using add-ins, click the Index tab in Microsoft Excel Help, type the following text

   add-in programs, overview