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.
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.