Jump to content
Macro Express Forums

Reduce Date On Repeat


cyberchief
 Share

Recommended Posts

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?

Link to comment
Share on other sites

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 by randallc
Link to comment
Share on other sites

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?)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...