I have created a macro that opens and runs a report. The report requests the user to input a date range. I have created several macros that automatically insert different date ranges. However, what I would like to do is create a single macro that pauses when the date range request box appears and then resumes running after the user has input the dates and then pressed Enter.
How would I do this?
Thanks.
How to pause application for input?
Moderators: Dorian (MJT support), JRL
-
- Newbie
- Posts: 2
- Joined: Fri Sep 10, 2004 5:34 pm
- Location: Rockville, MD
- Bob Hansen
- Automation Wizard
- Posts: 2475
- Joined: Tue Sep 24, 2002 3:47 am
- Location: Salem, New Hampshire, US
- Contact:
Simplest method is to use Input>
The default datas can come from any source, perhaps the latest date of all files in a directory? Perhaps the current date of a specific file? Just planting seeds for things to consider.
Could get more fancy by using Dialog with entry boxes for both start and end dates.
You may also want to consider some type of validation of the values entered.
You can also enter a default value for any Input>commandInput>StartDate,Please enter the start date......
Input>EndDate,Please enter the end date......
You could also make a default EndDate by adding n days to Date1. These are only defaults and can be overridden by operator.GetDate>Date1
Input>StartDate,Please enter the start date......,%Date1%
Input>EndDate,Please enter the end date......
The default datas can come from any source, perhaps the latest date of all files in a directory? Perhaps the current date of a specific file? Just planting seeds for things to consider.
Could get more fancy by using Dialog with entry boxes for both start and end dates.
You may also want to consider some type of validation of the values entered.
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!
Bob
A humble man and PROUD of it!