Excel: Importing Lotus 1-2-3 Macro Library Files to Excel
ID: Q112363
|
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
- Select the key you want to use to invoke the manager.
- Select Invoke Edit.
- Define the macros.
- Save the worksheet.
- Close the worksheet and exit Lotus 1-2-3.
- Start Microsoft Excel.
- 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
Additional query words:
Keywords :
Version : WINDOWS:3.0,4.0
Platform : WINDOWS
Issue type :