Microsoft KB Archive/112363

{|
 * width="100%"|

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

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 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.

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

 In Lotus 1-2-3, load the desired library with the following steps:  Select /Add-In Attach Select the macro library to be converted Choose Quit  Copy the library commands to a worksheet by choosing the Edit command in the Lotus Macro Library Manager.

 Select /Add-In Attach Select MACROMGR.ADN</li> Select the key you want to use to invoke the manager.</li> Select Invoke Edit.</li></ol> </li> Define the macros.</li> Save the worksheet.</li> Close the worksheet and exit Lotus 1-2-3.</li> Start Microsoft Excel.</li> Open the saved worksheet. You are now ready to use the macros in Microsoft Excel by pressing ALT+, where is the shortcut key assigned to run the desired macro (as defined in step 3).</li></ol>