Microsoft KB Archive/77751

= Lotus Macros That Do Not Directly Translate into Excel =

Article ID: 77751

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q77751



SUMMARY
The following is a list of Lotus 1-2-3 macro commands that do not have direct equivalents in Microsoft Excel. These commands either cannot be translated to Microsoft Excel commands when you use the Macro Translation Assistant or they will require extensive editing in Lotus before you are able to translate them properly.

Things to Look for When You Edit Macros in Lotus
WYSIWYG commands:

Microsoft Excel doesn't recognize the add-ins that provide WYSIWYG capability (such as Allways and Impress). These commands are preceded by a colon character in the macro.

Macros that reference another sheet in a workbook:

Later versions of Lotus 1-2-3 use multiple sheets, but Release 2.01 is a single-sheet program. Because the Microsoft Excel Macro Interpreter only recognizes macros compatible with Release 2.01 of Lotus 1-2-3, macros that reference another sheet will fail. To identify commands that reference another sheet, look for a sheet name followed by a colon (for example &quot;A:a1&quot;).

Names longer than a single letter:

Lotus 1-2-3 macros in Release 2.01 must be named &quot;\ &quot; where is a single letter. Later versions of Lotus 1-2-3 allow macros with longer names, but they cannot be run in Microsoft Excel.

Macros that do not work through the Macro Interpreter will not work any better if they are translated using the Macro Translation Assistant.



MORE INFORMATION
/DataRegressionInterceptCompute /DataRegressionInterceptZero /FileCombine /FileLink /FileXtract /GraphNameDelete /GraphNameReset /GraphOptionsFormat /GraphOptionsFormatA(-G) /GraphOptionsGrid /GraphOptionsScale /GraphOptionsScaleSkip /GraphOptionsScaleXscale /GraphOptionsScaleXscaleFormat /GraphOptionsScaleYscaleFormat /GraphOptionsTitlesFirst /GraphOptionsTitlesSecond /GraphOptionsTitlesX-axis /GraphOptionsTitlesY-axis /PrintFileAlign /PrintFileLine /PrintFileOptionsOtherFormatted /PrintFileOptionsOtherUnformatted /PrintFileOptionsOtherPg-length /PrintFileOptionsOtherSetup /PrintFilePage /PrintPrinterAlign /PrintPrinterLine /PrintPrinterOptionsOtherFormatted /PrintPrinterOptionsOtherUnformatted /PrintPrinterOptionsPg-length /PrintPrinterOptionsSetup /PrintPrinterPage /RangeFormat+/- /RangeFormatDate4(long intn'l) /RangeFormatDate5(short intn'l) /RangeFormatDateTime3(long intn'l) /RangeFormatDateTime4(short intn'l) /RangeFormatText /RangeInput /RangeNameReset /System /WorksheetColumnDisplay /WorksheetGlobalColumnwidth /WorksheetGlobalDefaultOtherClock /WorksheetGlobalDefaultOtherHelp /WorksheetGlobalDefaultOtherInternationalCurrency /WorksheetGlobalDefaultOtherInternationalDate /WorksheetGlobalDefaultOtherInternationalPunctuation /WorksheetGlobalDefaultOtherInternationalTime /WorksheetGlobalDefaultPrinterAuto-lf /WorksheetGlobalDefaultPrinterInterface /WorksheetGlobalDefaultPrinterName /WorksheetGlobalDefaultPrinterPg-length /WorksheetGlobalDefaultPrinterSetup /WorksheetGlobalDefaultPrinterWait /WorksheetGlobalDefaultStatus /WorksheetGlobalDefaultUpdate /WorksheetGlobalFormat /WorksheetGlobalFormat+/- /WorksheetGlobalFormatDate4(long intn'l) /WorksheetGlobalFormatDate5(short intn'l) /WorksheetGlobalFormatDateTime3(long intn'l) /WorksheetGlobalFormatDateTime4(short intn'l) /WorksheetGlobalLabel-prefix /WorksheetGlobalRecalculationColumnwise /WorksheetGlobalRecalculationRowwise /WorksheetStatus /WorksheetWindowUnsync /XM-activates the macro menu, ie. {MENUBRANCH} {?}, {BIGLEFT}, {BIGRIGHT}, {DISPATCH}, {LET}, {LOOK},{MENUBRANCH}, {MENUCALL}, {PGDN}, {PGUP}, {PUT}, {QUERY}, {RECALC}, {RECALCOL}.

