CONVERTING FROM LOTUS TO EXCEL

navyaa

Board Regular
Joined
Jul 7, 2002
Messages
223
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.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

lbass

Board Regular
Joined
Aug 15, 2002
Messages
104
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.
 

Forum statistics

Threads
1,144,770
Messages
5,726,186
Members
422,661
Latest member
foxleinlady

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top