Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dialog box to change macro values

Status
Not open for further replies.

Biggleslad

Technical User
Mar 16, 2003
1
GB
Would anyone have a small macro Dialog box script to prompt an administrator for a prompt value that changes the value in the macro?

For example, over 700 Impromptu reports are run from a Macro, and the period and Year are passed from the macro to the Impromptu filter prompt.These reports need to be run for different years and periods as a batch on demand, sometimes everal times a day, so the value in the macro needs to be prompted by a Dialog box.

Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top