Solved

Translating 123 Macros to Excel

Posted on 1998-03-04
9
793 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

863 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

25 Experts available now in Live!

Get 1:1 Help Now