?
Solved

Translating 123 Macros to Excel

Posted on 1998-03-04
9
Medium Priority
?
813 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

764 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