kashp
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by kashp
-
-
All,
I am trying to create a macro that will run multiple reports..currently my POS system only allows me to run one report at at time and save one report at a time. This is a pain because i have been asked to gather 2 years of data which is 730 reports. What i am not certain is 1. how do i move down a list (select dropdown (down) enter.. then the next one select dropdown (down)(down)(enter) 730 times and how do i hit save and make it so it saves it as audit 1 audit2 audit730 etc.
Here is my current script
WinWait, Aloha Manager - TableService,
IfWinNotActive, Aloha Manager - TableService, , WinActivate, Aloha Manager - TableService,
WinWaitActive, Aloha Manager - TableService,
MouseClick, left, 112, 26
Sleep, 100
MouseClick, left, 197, 413
Sleep, 100
WinWait, Select Date,
IfWinNotActive, Select Date, , WinActivate, Select Date,
WinWaitActive, Select Date,
MouseClick, left, 176, 49
Sleep, 100
Send, {DOWN}{ENTER}{ENTER} *******here is where i need it to go down one by one 730 times
WinWait, Select Transactions to Audit,
IfWinNotActive, Select Transactions to Audit, , WinActivate, Select Transactions to Audit,
WinWaitActive, Select Transactions to Audit,
MouseClick, left, 360, 263
Sleep, 100
MouseClick, left, 514, 313
Sleep, 100
MouseClick, left, 207, 403
Sleep, 100
WinWait, Save As,
IfWinNotActive, Save As, , WinActivate, Save As,
WinWaitActive, Save As,
Send, {LEFT}{LEFT}{LEFT}{LEFT}1{ENTER} ****here is where I need it to save to a new file name each
PLEASE HELP!
How to repeat, go down a list etc.
in Macro Express and Macro Express Pro
Posted
MakaPakaTobyHannah
Thank you for responding to my post, what I am trying to do is run reports for each day for the last two years. Unforunatly my system only allows me to run one report at a time and i have to select a new date from a drop down menu each time. I also have to rename each save becuase by default it names it Audit.rpt
So to answer your questions.
1. You are correct that after each report I need to add another down to select the next date to run. Today (down) 11/3/2011 (down) 11/2/2011 etc.
2. I only need the last 2 years of daily data so 730 reports is the max number I need.
3. The files can be named wahtever but I still can't figure out how to write a script that auto renames them each time.
Thank you again everyone for your help.
Best,
Kash