MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting lotus macro to excel


Posted by stephen La Van on July 25, 1999 7:00 PM

Does anyone know how to convert this lotus
macro symbol into VB?

{?}

\i
The whole lotus maco is
{?}{r 6}{down}
{l6{branch \i}


Posted by Ivan Moala on July 28, 1999 1:08 AM


Do you know what these symbols mean in Lotus Script?
if you do then you can lookup an equivalent excel command or a similar one.
Search the Excel online help for lotus macro conversion.

Posted by Ivan Moala on September 03, 1999 5:40 AM

{?} waits for user input ie type in something
and wait for enter key.
USE: inputbox function or method.

{r 6}{down} move Right 6 cells and Down 1
USE: activecell.offset(1,6)

{16{branch \i} =branch to \i ???
USE: goto (I think the branch is non returnable
ie macro does not return to calling macro)


Ivan Do you know what these symbols mean in Lotus Script? if you do then you can lookup an equivalent excel command or a similar one. Search the Excel online help for lotus macro conversion.

Posted by George C. Apazidis on December 29, 1999 8:38 AM

You can get a list (29 pages) of VB Equivalents
for Lotus Macro Commands at
http://www.xlhelp.com/Excel/Lotus.htm
scroll down a bit and click on the WE1277.exe
file. {?} waits for user input ie type in something and wait for enter key. USE: inputbox function or method. USE: activecell.offset(1,6) USE: goto (I think the branch is non returnable ie macro does not return to calling macro) Ivan : : Do you know what these symbols mean in Lotus Script? : if you do then you can lookup an equivalent excel command or a similar one. : Search the Excel online help for lotus macro conversion.