Solved

Translating 123 Macros to Excel

Posted on 1998-03-04
9
799 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
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 1

Author Comment

by:AndySB
ID: 1610899
Thanks.  Thats a help anyway.  Ill let you know if i come up with anything.
0
 
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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
This article will show you how to use shortcut menus in the Access run-time environment.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

828 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