Solved

Translating 123 Macros to Excel

Posted on 1998-03-04
9
791 Views
Last Modified: 2010-05-18
I have a large number of macros in use that are in Lotus 123 and am switching to Excel. I would like to translate/convert them to Excel format without having to rewrite them all.  Is there anyway of doing this!!?
0
Comment
Question by:AndySB
  • 5
  • 4
9 Comments
 
LVL 1

Author Comment

by:AndySB
ID: 1610896
Edited text of question
0
 
LVL 3

Accepted Solution

by:
frazer earned 50 total points
ID: 1610897
Hi,

This probably isn't the answer you want but I have looked long and hard for a translator between these two languages.
Unfortunatly I am yet to find one.

Below is a copy of a setion of MS's Knowledge Base which confirms my answer.


Lotus Macros That Do Not Directly Translate into Excel

Last reviewed: September 2, 1997
Article ID: Q77751

The information in this article applies to:

•Microsoft Excel for Windows, versions 2.1c, 2.1d, 3.0, 4.0, 4.0a, 5.0, 7.0, 97







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 "A:a1").

Names longer than a single letter:

Lotus 1-2-3 macros in Release 2.01 must be named "\<letter>" where <letter> 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}.





REFERENCES

Microsoft Excel version 4.0 Help, Search, Lotus 1-2-3, Overview of Macro Translation Assistant

Microsoft Excel version 3.0 Help, Index, Switching from Lotus 1-2-3, Macro Translation Assistant, Lotus 1-2-3 Commands that Require Editing to Translate

Microsoft Excel version 2.1d Help, Index, Macro Translation Assistant, Problematic Lotus 1-2-3 Macros, Problematic Lotus 1-2-3 Commands

Sorry I can't give you a better answer

Frazer
0
 
LVL 3

Expert Comment

by:frazer
ID: 1610898
Hi,

Try this address it will point you in the right direction of the Visual Basic Equivalents for Lotus Macro Commands.

http://support.microsoft.com/support/kb/articles/q148/2/40.asp

Hope this helps

Frazer
0
 
LVL 1

Author Comment

by:AndySB
ID: 1610899
Thanks.  Thats a help anyway.  Ill let you know if i come up with anything.
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 1

Author Comment

by:AndySB
ID: 1610900
Thanks.  Thats a help anyway.  Ill let you know if i come up with anything.
0
 
LVL 1

Author Comment

by:AndySB
ID: 1610901
Sorry.  Whats the Macro Translation Assistant?? Where can i get a look at it??
0
 
LVL 3

Expert Comment

by:frazer
ID: 1610902
Hi,

I got the information from the MS knowledge base. Below is the address of a search that i did, it gives you a sreies of links that may help you....

http://search.microsoft.com/searchbin/kb/mts.idq?D=excel+or+vbapps&A=T&G=&Fr=0&Sz=lotus&O=lotus&MSCOM_SRV=http://www.microsoft.com

Hope this helps

Frazer
0
 
LVL 1

Author Comment

by:AndySB
ID: 1610903
Great.  Taht will do for a start.  After reading the help file in Excel i see that i need two files.  TRANS.EXE and TRANS123.XLM.  I have found TRANS.EXE but cannot find TRANS123.XLM.  Where can i get it from??  Thanks.
0
 
LVL 3

Expert Comment

by:frazer
ID: 1610904
Hi,

I don't know

You could try

www.microsoft.com/excel/

or try a different search in the knowledge base

Happy hunting

Frazer
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
My experience with Windows 10 over a one year period and suggestions for smooth operation
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now