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

ID: Q112363

3.00 4.00 WINDOWS kb3rdparty

The information in this article applies to:

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

KBCategory: kb3rdparty KBSubcategory:

Additional reference words: 3.00 4.00 

Version           : 3.00 4.00
Platform          : WINDOWS

Last Reviewed: September 14, 1996