CONVERTING FROM LOTUS TO EXCEL

[navyaa]

Hi i am working on converting a Lotus spreadsheet to Excel...and I havent really worked much with Lotus.

I have to rewrite the macros so need to know what the macro is lotus does...

I have a few questions, I will paste the code and then ask what it does.....

{END}{U}{D}{END}{SELECT-DOWN}{SELECT-RIGHT}{RANGE-NAME-CREATE "REINSPMTS"}
{EDIT-QUICK-COPY CURYR_REINS,CREINSPMTS}{CALC}
{IF DIFF1=0}{BRANCH NOCHANGE}
{EDIT-GOTO BILLNOS}{END}{SELECT-DOWN}{EDIT-CLEAR}{ESC}
{EDIT-COPY BILLNO}{SELECT-DOWN (CURCNT-2)}{EDIT-PASTE}{ESC}
{END}{SELECT-DOWN}{RANGE-VALUE BILLNOS}{ESC}
{IF DIFF2<>0}{BRANCH QUESTION}
{EDIT-GOTO UPDATE}{WINDOWSON}

I need to underdstand...according to this code...If the value if the range DIFF1 is 0 it will jus go to macro NOCHANGE and then stop??

So does the DIFF2<>0 criteria only come in if first condition is not true( DIFF1=0 is not true)?

If someone can explain this i would be grateful forever....

I can provide more info if this is not enough...

THANK YOU...Navya.

 

[lbass]

NoChange is a range name.
When the condition of the if is met =0 True
Then it continues on that line if not 0 then
it goes to the next line.

So if = 0 then will go to the range named
NoChange. Then it depends what is in that range. If it is more macro code it will continue to execute.

See if that is what you wanted to know.
I'll be back in an hour or so. 5:30 ESDT.