Excel: Importing Lotus 1-2-3 Macro Library Files to Excel

• Microsoft Excel for Windows, versions 3.0 and 4.0

SUMMARY:

To import Lotus 1-2-3 macro library (*.MLB) files into Microsoft Excel, move the files into a Lotus 1-2-3 worksheet and then open that worksheet in Microsoft Excel.

MORE INFORMATION:

To transfer Lotus macro library files to Microsoft Excel, do the following:

1. In Lotus 1-2-3, load the desired library with the following steps:

   a. Select /Add-In Attach b. Select the macro library to be converted c. Choose Quit

2. Copy the library commands to a worksheet by choosing the Edit command in the Lotus Macro Library Manager.

   a. Select /Add-In Attach b. Select MACROMGR.ADN c. Select the key you want to use to invoke the manager. d. Select Invoke Edit.

3. Define the macros.

4. Save the worksheet.

5. Close the worksheet and exit Lotus 1-2-3.

6. Start Microsoft Excel.

7. Open the saved worksheet. You are now ready to use the macros in Microsoft Excel by pressing ALT+<key>, where <key> is the shortcut key assigned to run the desired macro (as defined in step 3).

REFERENCES

"Lotus 1-2-3 User's Guide," version 2.4, page 319. "Lotus 1-2-3 Functions and Macros Guide," version 2.4, pages 177-187