Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Translating 123 Macros to Excel

Posted on 1998-03-04
9
Medium Priority
?
816 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

636 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