Repeat until not recognizing a blank cell in excel

[sunilvedula]

hi all ,,

 

this the program i wrote. below is where i am finding the problem with my code. it is not recognizing the blamk cell in excel and not pasting the data that is copied int he variables. i am also attaching the complete code if someone can have a look and suggest me alterntive or methods to make it better.

<REM2:***copying the product no****><IVAR2:01:01:0><MMW2:155,92><LDCLK><CLIPC><TVAR2:17:03:><CLIPE><IFVAR2:4:17:2:T51><MMW2:564,433><LCLK><WFW:005><REM2:***checking the no of times the file is diarised****><REP3:06:000002:000001:0022:0:01:Route: JSTDYA><TEXTTYPE:<CONTROL>f><TEXTTYPE:Route: JSTDYA><TEXTTYPE:<ENTER>><MSD:50><GETCONTROL:01:IEXPLORE.EXE:002:#32770Microsoft Internet ExplorerButtonOK><IFCONTROL:03:01><EXITREP><ELSE><NMVAR:08:01:0:0000001:0:0000000><TEXTTYPE:<ESC>><CLIPC><TVAR2:22:03:><ENDIF><ENDREP><SETFOCUS:01><MSD:100><TEXTTYPE:<ENTER>><MSD:100><TEXTTYPE:<ESC>><MSD:100><REM2:***Choosing the Option for drop etc.....****><MENU2:2:T:20:CenterCenter:pls choose one Select one of the followingBMM
E-CHAMPST><IFVAR2:1:20:1:A><MENU2:2:T:18:CenterCenter:PSL CHOOSEChoose one of the following Drop
Diarise
Forward and DiaraiseT><IFVAR2:1:18:1:A><ACTIVATE2:Work item><WSHOW:Work item><TEXTTYPE:<ALT>l><TDELAY:4><MMW2:155,92><LDCLK><CLIPC><TVAR2:17:03:><CLIPE><MMW2:10,37><LDN><MMW2:164,38><LUP><CLIPC><TVAR2:19:03:><CLIPE><REM2:****adding the comment****><TVAR2:21:02:Fpls type in your commentsFFCenter:Center><TEXTTYPE:<TAB><TAB>><TEXTTYPE:%T21%><MENU2:2:T:22:CenterCenter:Pls chooseChoose one of the following OptionsConfirm
Confirm & get next
Confirm & move
Exit><IFVAR2:1:22:1:A><TEXTTYPE:<ALT>o><MSD:800><ELSE><IFVAR2:1:22:1:B><TEXTTYPE:<ALT>g><MSD:800><ELSE><IFVAR2:1:22:1:C><TEXTTYPE:<ALT>m><MSD:800><ELSE><IFVAR2:1:22:1:D><TEXTTYPE:<ALT>x><MSD:800><ENDIF><ENDIF><ENDIF><ENDIF><REM2:[b]****Moving to Excel sheet to pasted the drop data***><ACTIVATE2:LCD Tracker demo><WSHOW:LCD Tracker demo><TEXTTYPE:<CONTROL>g><TEXTTYPE:T7><TEXTTYPE:<ENTER>><MSD:200><CLIPC><TVAR2:23:03:><CLIPE><IFVAR2:4:23:1:T17><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%N1%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%T19%><TDELAY:1><ELSE><REP3:06:000001:000001:0023:0:01:><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%N1%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%T19%><TDELAY:1><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><EXITREP><TEXTTYPE:<ARROW DOWN>><CLIPC><TVAR2:23:03:><ENDREP><ENDIF><TDELAY:3>[/b]<ACTIVATE2:Work item><WSHOW:Work item><ELSE><REM2:***Choosing the Option for diarise etc....****><IFVAR2:1:18:1:B><ACTIVATE2:Work item><WSHOW:Work item><TEXTTYPE:<ALT>i><TDELAY:3><MMW2:155,92><LDCLK><CLIPC><TVAR2:17:03:><CLIPE><MMW2:10,37><LDN><MMW2:164,38><LUP><CLIPC><TVAR2:18:03:><CLIPE><REM2:****adding the comment****><TVAR2:21:02:Fpls type in your commentsFFCenter:Center><TEXTTYPE:<TAB><TAB>><TEXTTYPE:%T21%><MENU2:2:T:22:CenterCenter:Pls chooseChoose one of the following OptionsConfirm
Confirm & get next
Confirm & move
Exit><IFVAR2:1:22:1:A><TEXTTYPE:<ALT>o><ELSE><IFVAR2:1:22:1:B><TEXTTYPE:<ALT>g><ELSE><IFVAR2:1:22:1:C><TEXTTYPE:<ALT>m><ELSE><IFVAR2:1:22:1:D><TEXTTYPE:<ALT>x><ENDIF><ENDIF><ENDIF><ENDIF><REM2:****Moving to Excel sheet to pasted the drop data***><ACTIVATE2:LCD Tracker demo><WSHOW:LCD Tracker demo><TEXTTYPE:<CONTROL>g><TEXTTYPE:T7><TEXTTYPE:<ENTER>><MSD:200><CLIPC><TVAR2:23:03:><CLIPE><IFVAR2:4:23:1:T17><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%N1%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%T19%><TDELAY:1><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><ELSE><REP3:06:000001:000001:0023:0:01:><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%N1%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%T19%><TDELAY:1><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><EXITREP><TEXTTYPE:<ARROW DOWN>><CLIPC><TVAR2:23:03:><ENDREP><ENDIF><TDELAY:1><ACTIVATE2:Work item><WSHOW:Work item><ELSE><REM2:***Choosing the Option for Forward&Diarise etc....****><IFVAR2:1:18:1:C><ACTIVATE2:Work item><WSHOW:Work item><TEXTTYPE:<ALT>f><TDELAY:3><MMW2:155,92><LDCLK><CLIPC><TVAR2:17:03:><CLIPE><MMW2:10,37><LDN><MMW2:164,38><LUP><CLIPC><TVAR2:18:03:><CLIPE><REM2:****adding the comment****><TVAR2:21:02:Fpls type in your commentsFFCenter:Center><TEXTTYPE:<TAB><TAB>><TEXTTYPE:%T21%><MENU2:2:T:22:CenterCenter:Pls chooseChoose one of the following OptionsConfirm
Confirm & get next
Confirm & move
Exit><IFVAR2:1:22:1:A><TEXTTYPE:<ALT>o><ELSE><IFVAR2:1:22:1:B><TEXTTYPE:<ALT>g><ELSE><IFVAR2:1:22:1:C><TEXTTYPE:<ALT>m><ELSE><IFVAR2:1:22:1:D><TEXTTYPE:<ALT>x><ENDIF><ENDIF><ENDIF><ENDIF><REM2:****Moving to Excel sheet to pasted the drop data***><ACTIVATE2:LCD Tracker demo><WSHOW:LCD Tracker demo><TEXTTYPE:<CONTROL>g><TEXTTYPE:T7><TEXTTYPE:<ENTER>><MSD:200><CLIPC><TVAR2:23:03:><CLIPE><IFVAR2:4:23:1:T17><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%N1%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%T19%><TDELAY:1><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><ELSE><REP3:06:000002:000001:0023:0:01:><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%N1%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%T19%><TDELAY:1><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><EXITREP><TEXTTYPE:<ARROW DOWN>><CLIPC><TVAR2:23:03:><ENDREP><ENDIF><TDELAY:3><ACTIVATE2:Work item><WSHOW:Work item><ELSE><REM2:****When cm clicks cancel insted of choosing the optionn for drop etc...***><TDELAY:4><MMW2:155,92><LDCLK><CLIPC><TVAR2:17:03:><CLIPE><MMW2:10,37><LDN><MMW2:164,38><LUP><CLIPC><TVAR2:18:03:><CLIPE><ACTIVATE2:LCD Tracker demo><WSHOW:LCD Tracker demo><TEXTTYPE:<CONTROL>g><TEXTTYPE:s7><TEXTTYPE:<ENTER>><MSD:100><CLIPC><TVAR2:23:03:><CLIPE><REP3:06:000001:000001:0023:0:01:><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%N1%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%T19%><TDELAY:1><TEXTTYPE:<ARROW DOWN>><TEXTTYPE:<HOME>><EXITREP><TEXTTYPE:<ARROW DOWN>><CLIPC><TVAR2:23:03:><ENDREP><ENDIF><TDELAY:2><ACTIVATE2:Work item><WSHOW:Work item><ENDIF><ENDIF><TMVAR2:09:51:17:000:000:><ELSE><REM2:**** Choosing E-CHAMPS option****><IFVAR2:1:20:1:B><TMVAR2:09:51:17:000:000:><LAUNCHYES3:0:0112LCD Tracker demo<LAUNCH:C:\Documents and Settings\99222132\Desktop\LCD Tracker demo.xls><ACTIVATE2:LCD Tracker demo><WSHOW:LCD Tracker demo><TEXTTYPE:<CONTROL>g><TEXTTYPE:T7><TEXTTYPE:<ENTER>><MSD:100><CLIPC><TVAR2:23:03:><CLIPE><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><TEXTTYPE:%N1%><TEXTTYPE:<HOME>><DIS:<REP3:06:000002:000001:0023:0:01:><DIS:<TEXTTYPE:<ARROW DOWN>><DIS:<CLIPC><DIS:<TVAR2:23:03:><DIS:<MSD:200><DIS:<IFVAR2:1:23:1:><DIS:<TEXTTYPE:%T17%><DIS:<TEXTTYPE:<ARROW RIGHT>><DIS:<TEXTTYPE:%N1%><DIS:<TEXTTYPE:<HOME>><DIS:<ENDIF><DIS:<ENDREP><DIS:<TEXTTYPE:%T17%><DIS:<TEXTTYPE:<ARROW RIGHT>><DIS:<TEXTTYPE:%N1%><DIS:<TEXTTYPE:<HOME>><ITDELAY:2><ACTIVATE2:Work item><MACDEACT2:BMM><ELSE><MACRUN2:BMM><ENDIF><ENDIF><ELSE><REM2:***When WE COME TO BMM AFTER ECHAMPS ******><REM2:***Choosing the Option for drop etc....****><PAUSE2:000Top,00Lefthi success><MENU2:2:T:20:CenterCenter:pls choose one Select one of the followingBMM
E-CHAMPST><IFVAR2:1:20:1:A><MENU2:2:T:18:CenterCenter:PSL CHOOSEChoose one of the following Drop
Diarise
Forward and DiaraiseT><IFVAR2:1:18:1:A><ACTIVATE2:Work item><WSHOW:Work item><TEXTTYPE:<ALT>l><TDELAY:4><MMW2:155,92><LDCLK><CLIPC><TVAR2:17:03:><CLIPE><MMW2:10,37><LDN><MMW2:164,38><LUP><CLIPC><TVAR2:19:03:><CLIPE><REM2:****adding the comment****><TVAR2:21:02:Fpls type in your commentsFFCenter:Center><TEXTTYPE:<TAB><TAB>><TEXTTYPE:%T21%><MENU2:2:T:22:CenterCenter:Pls chooseChoose one of the following OptionsConfirm
Confirm & get next
Confirm & move
Exit><IFVAR2:1:22:1:A><TEXTTYPE:<ALT>o><MSD:800><ELSE><IFVAR2:1:22:1:B><TEXTTYPE:<ALT>g><MSD:800><ELSE><IFVAR2:1:22:1:C><TEXTTYPE:<ALT>m><MSD:800><ELSE><IFVAR2:1:22:1:D><TEXTTYPE:<ALT>x><MSD:800><ENDIF><ENDIF><ENDIF><ENDIF><REM2:****Moving to Excel sheet to pasted the drop data***><ACTIVATE2:LCD Tracker demo><WSHOW:LCD Tracker demo><TEXTTYPE:<CONTROL>g><TEXTTYPE:T7><TEXTTYPE:<ENTER>><MSD:200><CLIPC><TVAR2:23:03:><CLIPE><IFVAR2:4:23:1:T17><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%N1%><MSD:100><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%T19%><MSD:100><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><ELSE><REP3:06:000001:000001:0023:0:01:><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%N1%><MSD:100><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%T19%><MSD:100><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><EXITREP><TEXTTYPE:<ARROW DOWN>><CLIPC><TVAR2:23:03:><ENDREP><ENDIF><TDELAY:3><ACTIVATE2:Work item><WSHOW:Work item><ELSE><REM2:***Choosing the Option for diarise etc....****><IFVAR2:1:18:1:B><ACTIVATE2:Work item><WSHOW:Work item><TEXTTYPE:<ALT>i><TDELAY:3><MMW2:155,92><LDCLK><CLIPC><TVAR2:17:03:><CLIPE><MMW2:10,37><LDN><MMW2:164,38><LUP><CLIPC><TVAR2:19:03:><CLIPE><REM2:****adding the comment****><TVAR2:21:02:Fpls type in your commentsFFCenter:Center><TEXTTYPE:<TAB><TAB>><TEXTTYPE:%T21%><MENU2:2:T:22:CenterCenter:Pls chooseChoose one of the following OptionsConfirm
Confirm & get next
Confirm & move
Exit><IFVAR2:1:22:1:A><TEXTTYPE:<ALT>o><ELSE><IFVAR2:1:22:1:B><TEXTTYPE:<ALT>g><ELSE><IFVAR2:1:22:1:C><TEXTTYPE:<ALT>m><ELSE><IFVAR2:1:22:1:D><TEXTTYPE:<ALT>x><ENDIF><ENDIF><ENDIF><ENDIF><REM2:****Moving to Excel sheet to pasted the drop data***><ACTIVATE2:LCD Tracker demo><WSHOW:LCD Tracker demo><TEXTTYPE:<CONTROL>g><TEXTTYPE:T7><TEXTTYPE:<ENTER>><MSD:200><CLIPC><TVAR2:23:03:><CLIPE><IFVAR2:4:23:1:T17><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%N1%><MSD:100><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%T19%><MSD:100><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><ELSE><REP3:06:000001:000001:0023:0:01:><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%N1%><MSD:100><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%T19%><MSD:100><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><EXITREP><TEXTTYPE:<ARROW DOWN>><CLIPC><TVAR2:23:03:><ENDREP><ENDIF><TDELAY:3><ACTIVATE2:Work item><WSHOW:Work item><ELSE><REM2:***Choosing the Option for Forward&Diarise etc....****><IFVAR2:1:18:1:C><ACTIVATE2:Work item><WSHOW:Work item><TEXTTYPE:<ALT>f><TDELAY:3><MMW2:155,92><LDCLK><CLIPC><TVAR2:17:03:><CLIPE><MMW2:10,37><LDN><MMW2:164,38><LUP><CLIPC><TVAR2:19:03:><CLIPE><REM2:****adding the comment****><TVAR2:21:02:Fpls type in your commentsFFCenter:Center><TEXTTYPE:<TAB><TAB>><TEXTTYPE:%T21%><MENU2:2:T:22:CenterCenter:Pls chooseChoose one of the following OptionsConfirm
Confirm & get next
Confirm & move
Exit><IFVAR2:1:22:1:A><TEXTTYPE:<ALT>o><ELSE><IFVAR2:1:22:1:B><TEXTTYPE:<ALT>g><ELSE><IFVAR2:1:22:1:C><TEXTTYPE:<ALT>m><ELSE><IFVAR2:1:22:1:D><TEXTTYPE:<ALT>x><ENDIF><ENDIF><ENDIF><ENDIF><REM2:****Moving to Excel sheet to pasted the drop data***><ACTIVATE2:LCD Tracker demo><WSHOW:LCD Tracker demo><TEXTTYPE:<CONTROL>g><TEXTTYPE:T7><TEXTTYPE:<ENTER>><MSD:200><CLIPC><TVAR2:23:03:><CLIPE><IFVAR2:4:23:1:T17><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%N1%><MSD:100><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%T19%><MSD:100><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><ELSE><REP3:06:000001:000001:0023:0:01:><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%N1%><MSD:100><TEXTTYPE:<ARROW RIGHT>><MSD:100><TEXTTYPE:%T19%><MSD:100><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><EXITREP><TEXTTYPE:<ARROW DOWN>><CLIPC><TVAR2:23:03:><ENDREP><ENDIF><TDELAY:3><ACTIVATE2:Work item><WSHOW:Work item><ELSE><REM2:****When cm clicks cancel insted of choosing the optionn for drop etc...***><TDELAY:4><MMW2:155,92><LDCLK><CLIPC><TVAR2:17:03:><CLIPE><MMW2:10,37><LDN><MMW2:164,38><LUP><CLIPC><TVAR2:18:03:><CLIPE><ACTIVATE2:LCD Tracker demo><WSHOW:LCD Tracker demo><TEXTTYPE:<CONTROL>g><TEXTTYPE:s7><TEXTTYPE:<ENTER>><MSD:100><CLIPC><TVAR2:23:03:><CLIPE><REP3:06:000001:000001:0023:0:01:><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%N1%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%T19%><TDELAY:1><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><EXITREP><TEXTTYPE:<ARROW DOWN>><CLIPC><TVAR2:23:03:><ENDREP><ENDIF><ACTIVATE2:Work item><WSHOW:Work item><ENDIF><ENDIF><ELSE><DIS:<REM2:**** Choosing E-CHAMPS option****><DIS:<IFVAR2:1:20:1:B><DIS:<ACTIVATE2:LCD Tracker demo><DIS:<WSHOW:LCD Tracker demo><DIS:<TEXTTYPE:<CONTROL>g><DIS:<TEXTTYPE:T7><DIS:<TEXTTYPE:<ENTER>><DIS:<MSD:100><DIS:<CLIPC><DIS:<TVAR2:23:03:><DIS:<CLIPE><DIS:<REP3:06:000001:000001:0023:0:01:><DIS:<TEXTTYPE:%T17%><DIS:<TEXTTYPE:<ARROW RIGHT>><DIS:<MSD:100><DIS:<TEXTTYPE:%N1%><DIS:<MSD:100><DIS:<TEXTTYPE:<ARROW RIGHT>><DIS:<MSD:100><DIS:<TEXTTYPE:%T19%><DIS:<MSD:100><DIS:<TEXTTYPE:<ARROW DOWN>><DIS:<CLIPC><DIS:<TVAR2:23:03:><DIS:<ENDREP><DIS:<TEXTTYPE:<HOME>><DIS:<TEXTTYPE:<ARROW UP>><DIS:<ITDELAY:2><DIS:<ACTIVATE2:Work item><DIS:<MACDEACT2:BMM><DIS:<ELSE><DIS:<MACRUN2:BMM><DIS:<ENDIF><ENDIF><ENDIF>

 

<ACTIVATE2:LCD Tracker demo><WSHOW:LCD Tracker demo><TEXTTYPE:<CONTROL>g><TEXTTYPE:T7><TEXTTYPE:<ENTER>><MSD:200><CLIPC><TVAR2:23:03:><CLIPE><IFVAR2:4:23:1:T17><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%N1%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%T19%><TDELAY:1><ELSE><REP3:06:000001:000001:0023:0:01:><TEXTTYPE:%T17%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%N1%><TEXTTYPE:<ARROW RIGHT>><TDELAY:1><TEXTTYPE:%T19%><TDELAY:1><TEXTTYPE:<HOME>><TEXTTYPE:<ARROW DOWN>><EXITREP><TEXTTYPE:<ARROW DOWN>><CLIPC><TVAR2:23:03:><ENDREP><ENDIF><TDELAY:3>

[sunilvedula]

Maybe that was too huge a code to check.. please find the below code where my repeat function is not working and goes for infinite loop. maybe this is a smal thing but could not find the reason for error. (i did try various ways to resolve this beofre comming to the forum but alas!)

 

<REM2:****Moving to Excel sheet to pasted the drop data***><ACTIVATE2:LCD Tracker demo><WSHOW:LCD Tracker demo><TEXTTYPE:<CONTROL>g><TEXTTYPE:B7><TEXTTYPE:<ENTER>><MSD:100><CLIPC><TVAR2:23:03:><CLIPE><IFVAR2:1:23:2: ><REP3:08:000001:000001:0023:0:01:><TEXTTYPE:<ARROW DOWN>><CLIPC><TVAR2:23:03:><MSD:200><ENDREP><ELSE><TEXTTYPE:%T1%><TEXTTYPE:<ARROW RIGHT>><TEXTTYPE:%N1%><TEXTTYPE:<ARROW RIGHT>><TEXTTYPE:%T2%><TEXTTYPE:<HOME>><ENDIF>

 

pls help me find the error !. sorry to ask u all for sucha small thing

[sunilvedula]

Hey all,

 

EUREKA! i found it. we need to convert the blank cell in excel to ASCII and pass that to a variable (n) and then compare it. i got it solved. thanks a lot!