cyberchief Posted March 21, 2005 Report Share Posted March 21, 2005 Ok... I have searched the help files... but have come up with nothing. Hope you proffesionals can assist. I have a macro pulling records using MMYY for date. Sometimes, there are no records for that specific MMYY (current MMYY). I have the repeat set to repeat 6 times until either the record is found, or nothing is found... If no record is found as of the current MMYY, I need the repeat to reduce the query by 1 month... Is there anyway to do this on a repeat? I know you can set the Date as a variable, and you can reduce the variable by 1, but will this reduce the month? Or will it reduce the last "Y" as it would an interger. TIA! Am I missing something? Quote Link to comment Share on other sites More sharing options...
randallc Posted March 22, 2005 Report Share Posted March 22, 2005 (edited) Hi, Good fun! // Set Current date by MMYY to Var %T1%Date/Time: Save "MMYY" into %T1% Text Box Display: Current Month // Set %N1% months back ; date by MMYY to Var %T1% // Put %N1% in "past" months box Variable Set Integer %N1% to 1 Date/Time: Save "MMYY" into %T1% Text Box Display: Back by %N1% Months 0305 0205 <REM2:Set Current date by MMYY to Var %T1%><DT:MMYYT:01:1:><TBOX4:T:1:CenterCenter000278000200:000:Current MonthT1=%T1%><REM2:Set %N1% months back; date by MMYY to Var %T1%><IVAR2:01:01:1><DT:MMYYT:01:3:{P00000}{P0%N1%}{P00000}{P00000}><TBOX4:T:1:CenterCenter000278000200:000:Back by %N1% MonthsT1=%T1%> <REM2:Set %N1% months back; date by MMYY to Var %T1%><REP3:01:000000:000001:00003:1:01:><DT:MMYYT:01:3:{P00000}{P0%N1%}{P00000}{P00000}><TBOX4:T:1:CenterCenter000278000200:000:Back by %N1% MonthsT1=%T1%><ENDREP> See my note on dates and the help files; Date Formats [PS - Do you search this Forum as well? - on top right of Web Site? -I have some difficulty with it, as it seems to me to miss some things, and I enter my queries a number of different ways before giving up! - There is also the old newsgroup archive of answers somewhere.... I think at PGM site?] Best, Randall EDIT1; added code which shows the repeat Edited May 9, 2005 by randallc Quote Link to comment Share on other sites More sharing options...
cyberchief Posted March 22, 2005 Author Report Share Posted March 22, 2005 I actually went through ALL threads before I ever started posting here... but I don't know of the PGM site. Do you have a URL? I also searched the help files. THe below code "looks" to me as if it will go back 1 month. I figured that much out... but, I need it to continue going back 1 month for up to 6 months back if the criteria are not met (in repeat). If you set the variable to MMYY (current MMYY), every time the process repeats, it will reset the variable to the current MMYY and will never go beyond 1 month back... this is how it "looks" to me anyhow. Am I reading this wrong? Is it a matter of where you put the variable declaration in the repeat process (prior to repeat?) Quote Link to comment Share on other sites More sharing options...
cyberchief Posted March 22, 2005 Author Report Share Posted March 22, 2005 Randall, YOU ARE THE MAN!!! Got it figured out... just a matter of where to place the variables in the repeat process. Your suggestion now works perfectly!!! If Variable %T2% = "REQUESTED" Variable Set Integer %N1% to 0 Repeat Until %N1% = 6 Variable Modify Integer: %N1% = %N1% + 1 Date/Time: Save "MMYY" into %T7% <IFVAR2:1:02:1:REQUESTED><IVAR2:01:01:0><REP3:08:000001:000002:0001:0:01:6><NMVAR:01:01:1:0000001:2:0000001><DT:MMYYT:07:3:{P00000}{P0%N1%}{P00000}{P00000}> Thanks a TON!!!! Quote Link to comment Share on other sites More sharing options...
floyd Posted March 22, 2005 Report Share Posted March 22, 2005 Re: cyberchief - but I don't know of the PGM site. Do you have a URL? I also searched the help files.Randall is referring to this Archives link. Prior to having the Macro Express forum here at www.pgmacros.com, it was a newsgroup accessible only through email clients like Outlook. These are the archived topics from there. Quote Link to comment Share on other sites More sharing options...
cyberchief Posted March 22, 2005 Author Report Share Posted March 22, 2005 Sounds good. Thank you very much. You all have been very helpful. I hope I don't seem to quick on the questions... I really do research before posting... I check the help files... tutorials... forum... Sometimes, I just need a little push in the right direction. A little hint will go far with me... I can usually pick things up quickly. I have had this program installed for 2 days.... here is the code I have already typed. I know I have a ways to go to simplify... but this macro works great. Variable Set String %T11% "Customer Name" Variable Set String %T12% "Customer Attn" Variable Set String %T13% "Customer Address" Variable Set String %T14% "Customer City/State" Variable Set String %T15% "Zip" Activate Window: "CSR Macro Program" Delay 0.2 Seconds Clipboard Copy Delay 0.2 Seconds Delay 0.2 Seconds Variable Set String %T1% from Clipboard Repeat Until %T1% = "" Variable Modify String: Copy Part of %T1% to %T2% If Variable %T2% = "970" OR If Variable %T2% = "303" OR If Variable %T2% = "307" OR If Variable %T2% = "719" OR If Variable %T2% = "720" Variable Set String %T3% "CO" Activate Window: "OSCAR_CO_WY - USWest Connect" Else If Variable %T2% = "612" OR If Variable %T2% = "651" OR If Variable %T2% = "763" OR If Variable %T2% = "952" OR If Variable %T2% = "218" OR If Variable %T2% = "507" OR If Variable %T2% = "320" OR If Variable %T2% = "701" Variable Set String %T3% "NO" Activate Window: "OSCAR_EAST_NO - USWest Connect" Else If Variable %T2% = "308" OR If Variable %T2% = "319" OR If Variable %T2% = "402" OR If Variable %T2% = "515" OR If Variable %T2% = "563" OR If Variable %T2% = "605" OR If Variable %T2% = "641" OR If Variable %T2% = "712" Variable Set String %T3% "SO" Activate Window: "OSCAR_EAST_SO - USWest Connect" Else If Variable %T2% = "208" OR If Variable %T2% = "385" OR If Variable %T2% = "406" OR If Variable %T2% = "435" OR If Variable %T2% = "801" Variable Set String %T3% "UT" Activate Window: "OSCAR_AZ_ID_MT_NM_UT - USWest Connect" Else If Variable %T2% = "480" OR If Variable %T2% = "505" OR If Variable %T2% = "520" OR If Variable %T2% = "602" OR If Variable %T2% = "623" OR If Variable %T2% = "928" Variable Set String %T3% "NM" Activate Window: "OSCAR_AZ_ID_MT_NM_UT - USWest Connect" Else If Variable %T2% = "206" OR If Variable %T2% = "253" OR If Variable %T2% = "360" OR If Variable %T2% = "425" OR If Variable %T2% = "509" OR If Variable %T2% = "564" Variable Set String %T3% "WA" Activate Window: "OSCAR_WESTERN - USWest Connect" Else If Variable %T2% = "503" OR If Variable %T2% = "541" Variable Set String %T3% "OR" Activate Window: "OSCAR_WESTERN - USWest Connect" End If End If End If End If End If End If End If Delay 0.2 Seconds Text Type: <HOME> Delay 0.2 Seconds Text Type: <SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><S... Delay 0.3 Seconds Text Type: <F1> Delay 0.3 Seconds Clipboard Paste Text Type: <HOME> Delay 0.5 Seconds Text Type: <TAB><TAB><TAB><TAB><TAB><TAB> Date: Type Out MM (03) Date: Type Out YY (00) Text Type: <TAB><TAB> Text Type: %T3% Delay 0.2 Seconds Text Type: <F5> Delay 2 Seconds Clear All Variables: From 1 To 10 Clipboard Empty Mouse Move Window 493, 96 Mouse Left Button Double Click Clipboard Copy Delay 0.2 Seconds Text Type: <TAB> Variable Set String %T2% from Clipboard If Variable %T2% = "DUPLICATES" Delay 0.5 Seconds Text Type: <HOME> Text Type: Dupt Delay 0.5 Seconds Text Type: <F5> Mouse Move Screen 25, 217 Mouse Left Button Click Text Type: <SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW DOWN><ARROW DOWN><ARROW DOWN><AR... Delay 0.5 Seconds Clipboard Copy Delay 0.5 Seconds If Clipboard Contains "10" Variable Set Integer %N10% to 10 Else If Clipboard Contains "9" Variable Set Integer %N10% to 9 Else If Clipboard Contains "8" Variable Set Integer %N10% to 8 Else If Clipboard Contains "7" Variable Set Integer %N10% to 7 Else If Clipboard Contains "6" Variable Set Integer %N10% to 6 Else If Clipboard Contains "5" Variable Set Integer %N10% to 5 Else If Clipboard Contains "4" Variable Set Integer %N10% to 4 Else If Clipboard Contains "3" Variable Set Integer %N10% to 3 Else If Clipboard Contains " 2" Variable Set Integer %N10% to 2 Else If Clipboard Contains " 1" Variable Set Integer %N10% to 1 End If End If End If End If End If End If End If End If End If End If Delay 1 Seconds Text Type: Get %N10% Text Type: <F5> Delay 0.5 Seconds Text Type: <F3> Delay 1 Seconds Text Type: %T11% Text Type: <TAB><TAB> Delay 0.2 Seconds Text Type: %T12% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T13% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T14% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T15% Delay 0.2 Seconds Text Type: <F3> Delay 0.5 Seconds Mouse Move Window 497, 100 Mouse Left Button Click Text Type: <SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT>... Clipboard Cut Delay 0.5 Seconds Text Type: <HOME> Delay 0.5 Seconds Activate Window: "CSR Macro Program" Delay 0.3 Seconds Text Type: <ARROW RIGHT> Delay 0.3 Seconds Clipboard Paste Delay 0.2 Seconds Text Type: <ARROW DOWN><ARROW LEFT> Delay 0.2 Seconds Else If Variable %T2% = "REQUESTED" Variable Set Integer %N1% to 0 Repeat Until %N1% = 6 Variable Modify Integer: %N1% = %N1% + 1 Date/Time: Save "MMYY" into %T7% Text Type: <HOME> Delay 0.5 Seconds Text Type: <TAB><TAB><TAB><TAB><TAB><TAB> Text Type: %T7% Text Type: <F5> Delay 1 Seconds Clipboard Empty Clear Text Variables: From 5 To 5 Mouse Move Window 493, 96 Mouse Left Button Double Click Clipboard Copy Delay 0.2 Seconds Variable Set String %T5% from Clipboard If Variable %T5% = "DUPLICATES" Delay 0.2 Seconds Text Type: <HOME> Text Type: Dupt Text Type: <F5> Delay 0.5 Seconds Mouse Move Screen 25, 217 Mouse Left Button Click Text Type: <SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW DOWN><ARROW DOWN><ARROW DOWN><AR... Delay 0.5 Seconds Clipboard Copy Delay 0.5 Seconds If Clipboard Contains "10" Variable Set Integer %N10% to 10 Else If Clipboard Contains "9" Variable Set Integer %N10% to 9 Else If Clipboard Contains "8" Variable Set Integer %N10% to 8 Else If Clipboard Contains "7" Variable Set Integer %N10% to 7 Else If Clipboard Contains "6" Variable Set Integer %N10% to 6 Else If Clipboard Contains "5" Variable Set Integer %N10% to 5 Else If Clipboard Contains "4" Variable Set Integer %N10% to 4 Else If Clipboard Contains "3" Variable Set Integer %N10% to 3 Else If Clipboard Contains " 2" Variable Set Integer %N10% to 2 Else If Clipboard Contains " 1" Variable Set Integer %N10% to 1 End If End If End If End If End If End If End If End If End If End If Delay 1 Seconds Text Type: Get %N10% Delay 0.3 Seconds Text Type: <F5> Delay 0.5 Seconds Text Type: <F3> Delay 0.5 Seconds Text Type: %T11% Text Type: <TAB><TAB> Delay 0.2 Seconds Text Type: %T12% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T13% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T14% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T15% Delay 0.5 Seconds Text Type: <F3> Delay 0.5 Seconds Mouse Move Window 493, 96 Mouse Left Button Click Text Type: <SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT>... Clipboard Copy Delay 0.5 Seconds Text Type: <HOME><F1> Activate Window: "CSR Macro Program" Delay 0.2 Seconds Text Type: <ARROW RIGHT> Delay 0.3 Seconds Clipboard Paste Text Type: <ARROW DOWN><ARROW LEFT> Break Else If Variable %T5% = " " Text Type: <HOME> Delay 1 Seconds Text Type: <F3> Delay 1 Seconds Delay 0.2 Seconds Text Type: %T11% Text Type: <TAB><TAB> Delay 0.2 Seconds Text Type: %T12% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T13% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T14% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T15% Delay 0.2 Seconds Text Type: <F3> Delay 0.5 Seconds Mouse Move Window 493, 96 Mouse Left Button Click Text Type: <SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT>... Clipboard Copy Delay 0.1 Seconds Text Type: <HOME> Delay 0.2 Seconds Activate Window: "CSR Macro Program" Delay 0.2 Seconds Text Type: <ARROW RIGHT> Delay 0.3 Seconds Clipboard Paste Text Type: <ARROW DOWN><ARROW LEFT> Break Else If Variable %T2% = "REQUESTED" AND If Variable %N1% = 6 Activate Window: "CSR Macro Program" Delay 0.2 Seconds Delay 0.2 Seconds Text Type: <ARROW RIGHT> Delay 0.2 Seconds Text Type: NO ACCOUNT FOUND Text Type: <ARROW DOWN><ARROW LEFT> Delay 0.2 Seconds Break End If End If End If Repeat End Else If Variable %T1% = "" Text Type: <HOME> Delay 1 Seconds Text Type: <F3> Delay 1 Seconds Text Type: %T11% Text Type: <TAB><TAB> Delay 0.2 Seconds Text Type: %T12% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T13% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T14% Text Type: <TAB> Delay 0.2 Seconds Text Type: %T15% Delay 0.2 Seconds Text Type: <F3> Delay 0.5 Seconds Mouse Move Window 493, 96 Mouse Left Button Click Text Type: <SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT>... Clipboard Copy Delay 0.1 Seconds Text Type: <HOME> Delay 0.2 Seconds Activate Window: "CSR Macro Program" Delay 0.2 Seconds Text Type: <ARROW RIGHT> Delay 0.3 Seconds Clipboard Paste Delay 0.1 Seconds Clipboard Empty Clear Text Variables: From 1 To 5 Text Type: <ARROW DOWN><ARROW LEFT> Delay 0.3 Seconds End If End If End If Clipboard Copy Variable Set String %T1% from Clipboard If Variable %T1% < "1" Text Box Display: MACRO COMPLETE Macro Stop Else End If Repeat End <TVAR2:11:01:Customer Name><TVAR2:12:01:Customer Attn><TVAR2:13:01:Customer Address><TVAR2:14:01:Customer City/State><TVAR2:15:01:Zip><ACTIVATE2:CSR Macro Program><DELAY:.2><CLIPC><DELAY:.2><DELAY:.2><TVAR2:01:03:><REP3:08:000001:000001:0001:0:01:><TMVAR2:10:02:01:001:003:><IFVAR2:1:02:1:970><OR><IFVAR2:1:02:1:303><OR><IFVAR2:1:02:1:307><OR><IFVAR2:1:02:1:719><OR><IFVAR2:1:02:1:720><TVAR2:03:01:CO><ACTIVATE2:OSCAR_CO_WY - USWest Connect><ELSE><IFVAR2:1:02:1:612><OR><IFVAR2:1:02:1:651><OR><IFVAR2:1:02:1:763><OR><IFVAR2:1:02:1:952><OR><IFVAR2:1:02:1:218><OR><IFVAR2:1:02:1:507><OR><IFVAR2:1:02:1:320><OR><IFVAR2:1:02:1:701><TVAR2:03:01:NO><ACTIVATE2:OSCAR_EAST_NO - USWest Connect><ELSE><IFVAR2:1:02:1:308><OR><IFVAR2:1:02:1:319><OR><IFVAR2:1:02:1:402><OR><IFVAR2:1:02:1:515><OR><IFVAR2:1:02:1:563><OR><IFVAR2:1:02:1:605><OR><IFVAR2:1:02:1:641><OR><IFVAR2:1:02:1:712><TVAR2:03:01:SO><ACTIVATE2:OSCAR_EAST_SO - USWest Connect><ELSE><IFVAR2:1:02:1:208><OR><IFVAR2:1:02:1:385><OR><IFVAR2:1:02:1:406><OR><IFVAR2:1:02:1:435><OR><IFVAR2:1:02:1:801><TVAR2:03:01:UT><ACTIVATE2:OSCAR_AZ_ID_MT_NM_UT - USWest Connect><ELSE><IFVAR2:1:02:1:480><OR><IFVAR2:1:02:1:505><OR><IFVAR2:1:02:1:520><OR><IFVAR2:1:02:1:602><OR><IFVAR2:1:02:1:623><OR><IFVAR2:1:02:1:928><TVAR2:03:01:NM><ACTIVATE2:OSCAR_AZ_ID_MT_NM_UT - USWest Connect><ELSE><IFVAR2:1:02:1:206><OR><IFVAR2:1:02:1:253><OR><IFVAR2:1:02:1:360><OR><IFVAR2:1:02:1:425><OR><IFVAR2:1:02:1:509><OR><IFVAR2:1:02:1:564><TVAR2:03:01:WA><ACTIVATE2:OSCAR_WESTERN - USWest Connect><ELSE><IFVAR2:1:02:1:503><OR><IFVAR2:1:02:1:541><TVAR2:03:01:OR><ACTIVATE2:OSCAR_WESTERN - USWest Connect><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><DELAY:.2><TEXTTYPE:<HOME>><DELAY:.2><TEXTTYPE:<SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE><SPACE>><DELAY:.3><TEXTTYPE:<F1>><DELAY:.3><CLIPP><TEXTTYPE:<HOME>><DELAY:.5><TEXTTYPE:<TAB><TAB><TAB><TAB><TAB><TAB>><MM{YP000}{P000}><YY{NP000}{P000}><TEXTTYPE:<TAB><TAB>><TEXTTYPE:%T3%><DELAY:.2><TEXTTYPE:<F5>><DELAY:2><CLEARVAR1:A:1:10><CLIPE><MMW2:493,96><LDCLK><CLIPC><DELAY:.2><TEXTTYPE:<TAB>><TVAR2:02:03:><IFVAR2:1:02:1:DUPLICATES><DELAY:.5><TEXTTYPE:<HOME>><TEXTTYPE:Dupt><DELAY:.5><TEXTTYPE:<F5>><MMS2:25,217><LCLK><TEXTTYPE:<SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><SHIFTU>><DELAY:.5><CLIPC><DELAY:.5><IFOTH2:08:1:10><IVAR2:10:01:10><ELSE><IFOTH2:08:1:9><IVAR2:10:01:9><ELSE><IFOTH2:08:1:8><IVAR2:10:01:8><ELSE><IFOTH2:08:1:7><IVAR2:10:01:7><ELSE><IFOTH2:08:1:6><IVAR2:10:01:6><ELSE><IFOTH2:08:1:5><IVAR2:10:01:5><ELSE><IFOTH2:08:1:4><IVAR2:10:01:4><ELSE><IFOTH2:08:1:3><IVAR2:10:01:3><ELSE><IFOTH2:08:1: 2><IVAR2:10:01:2><ELSE><IFOTH2:08:1: 1><IVAR2:10:01:1><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><DELAY:1><TEXTTYPE:Get %N10%><TEXTTYPE:<F5>><DELAY:.5><TEXTTYPE:<F3>><DELAY:1><TEXTTYPE:%T11%><TEXTTYPE:<TAB><TAB>><DELAY:.2><TEXTTYPE:%T12%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T13%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T14%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T15%><DELAY:.2><TEXTTYPE:<F3>><DELAY:.5><MMW2:497,100><LCLK><TEXTTYPE:<SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><SHIFTU>><CLIPT><DELAY:.5><TEXTTYPE:<HOME>><DELAY:.5><ACTIVATE2:CSR Macro Program><DELAY:.3><TEXTTYPE:<ARROW RIGHT>><DELAY:.3><CLIPP><DELAY:.2><TEXTTYPE:<ARROW DOWN><ARROW LEFT>><DELAY:.2><ELSE><IFVAR2:1:02:1:REQUESTED><IVAR2:01:01:0><REP3:08:000001:000002:0001:0:01:6><NMVAR:01:01:1:0000001:2:0000001><DT:MMYYT:07:3:{P00000}{P0%N1%}{P00000}{P00000}><TEXTTYPE:<HOME>><DELAY:.5><TEXTTYPE:<TAB><TAB><TAB><TAB><TAB><TAB>><TEXTTYPE:%T7%><TEXTTYPE:<F5>><DELAY:1><CLIPE><CLEARVAR1:T:5:5><MMW2:493,96><LDCLK><CLIPC><DELAY:.2><TVAR2:05:03:><IFVAR2:1:05:1:DUPLICATES><DELAY:.2><TEXTTYPE:<HOME>><TEXTTYPE:Dupt><TEXTTYPE:<F5>><DELAY:.5><MMS2:25,217><LCLK><TEXTTYPE:<SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><SHIFTU>><DELAY:.5><CLIPC><DELAY:.5><IFOTH2:08:1:10><IVAR2:10:01:10><ELSE><IFOTH2:08:1:9><IVAR2:10:01:9><ELSE><IFOTH2:08:1:8><IVAR2:10:01:8><ELSE><IFOTH2:08:1:7><IVAR2:10:01:7><ELSE><IFOTH2:08:1:6><IVAR2:10:01:6><ELSE><IFOTH2:08:1:5><IVAR2:10:01:5><ELSE><IFOTH2:08:1:4><IVAR2:10:01:4><ELSE><IFOTH2:08:1:3><IVAR2:10:01:3><ELSE><IFOTH2:08:1: 2><IVAR2:10:01:2><ELSE><IFOTH2:08:1: 1><IVAR2:10:01:1><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><DELAY:1><TEXTTYPE:Get %N10%><DELAY:.3><TEXTTYPE:<F5>><DELAY:.5><TEXTTYPE:<F3>><DELAY:.5><TEXTTYPE:%T11%><TEXTTYPE:<TAB><TAB>><DELAY:.2><TEXTTYPE:%T12%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T13%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T14%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T15%><DELAY:.5><TEXTTYPE:<F3>><DELAY:.5><MMW2:493,96><LCLK><TEXTTYPE:<SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><SHIFTU>><CLIPC><DELAY:.5><TEXTTYPE:<HOME><F1>><ACTIVATE2:CSR Macro Program><DELAY:.2><TEXTTYPE:<ARROW RIGHT>><DELAY:.3><CLIPP><TEXTTYPE:<ARROW DOWN><ARROW LEFT>><BREAK><ELSE><IFVAR2:1:05:1: ><TEXTTYPE:<HOME>><DELAY:1><TEXTTYPE:<F3>><DELAY:1><DELAY:.2><TEXTTYPE:%T11%><TEXTTYPE:<TAB><TAB>><DELAY:.2><TEXTTYPE:%T12%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T13%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T14%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T15%><DELAY:.2><TEXTTYPE:<F3>><DELAY:.5><MMW2:493,96><LCLK><TEXTTYPE:<SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><SHIFTU>><CLIPC><DELAY:.1><TEXTTYPE:<HOME>><DELAY:.2><ACTIVATE2:CSR Macro Program><DELAY:.2><TEXTTYPE:<ARROW RIGHT>><DELAY:.3><CLIPP><TEXTTYPE:<ARROW DOWN><ARROW LEFT>><BREAK><ELSE><IFVAR2:1:02:1:REQUESTED><AND><IFVAR2:2:01:1:6><ACTIVATE2:CSR Macro Program><DELAY:.2><DELAY:.2><TEXTTYPE:<ARROW RIGHT>><DELAY:.2><TEXTTYPE:NO ACCOUNT FOUND><TEXTTYPE:<ARROW DOWN><ARROW LEFT>><DELAY:.2><BREAK><ENDIF><ENDIF><ENDIF><ENDREP><ELSE><IFVAR2:1:01:1:><TEXTTYPE:<HOME>><DELAY:1><TEXTTYPE:<F3>><DELAY:1><TEXTTYPE:%T11%><TEXTTYPE:<TAB><TAB>><DELAY:.2><TEXTTYPE:%T12%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T13%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T14%><TEXTTYPE:<TAB>><DELAY:.2><TEXTTYPE:%T15%><DELAY:.2><TEXTTYPE:<F3>><DELAY:.5><MMW2:493,96><LCLK><TEXTTYPE:<SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><SHIFTU>><CLIPC><DELAY:.1><TEXTTYPE:<HOME>><DELAY:.2><ACTIVATE2:CSR Macro Program><DELAY:.2><TEXTTYPE:<ARROW RIGHT>><DELAY:.3><CLIPP><DELAY:.1><CLIPE><CLEARVAR1:T:1:5><TEXTTYPE:<ARROW DOWN><ARROW LEFT>><DELAY:.3><ENDIF><ENDIF><ENDIF><CLIPC><TVAR2:01:03:><IFVAR2:1:01:3:1><TBOX4:T:1:CenterCenter000278000200:000:MACRO COMPLETEYour Macro has completed. Please check the assigned spreadsheet for status per item><MSTOP><ELSE><ENDIF><ENDREP> Quote Link to comment Share on other sites More sharing options...
randallc Posted March 23, 2005 Report Share Posted March 23, 2005 A little hint will go far with me... I can usually pick things up quickly. I have had this program installed for 2 days.... Yes, fantastic! Only 2 days - well done, Randall Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.