By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,220 Members | 978 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,220 IT Pros & Developers. It's quick & easy.

Set date range for multiple reports where reports run from macro

P: 1
I'm looking for a method to enter and retain a start date and end date for use with a macro that runs 11 month-end reports that each require the same start date and end date.
FYI- currently, the macro runs and requires entry for start and end dates for each report as it opens. Where no data is available, the macro informs of no data, requires acknowledgement, then proceeds to the next report.
Oct 5 '06 #1
Share this Question
Share on Google+
1 Reply


100+
P: 143
Don't do it from a macro, take the dates from a form.
Oct 6 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.