Automate Report Output

A

Anthony Viscomi

I would like to create some sort of script/macro to automate the ouptut of 5
reports into 1 XLS (Spreadsheet), with each individual report as their own
Worksheet. I know how to perform this task if I were just working with 1
report and 1 spreadsheet, I'm just not sure how to handle the defining of a
Worksheet. Any thoughts?

Thanks!
Anthony Viscomi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Output Report to Multiple XLS Worksheets 3
Hiding a Field on a Report 1
Do Menu Item 2
Print report sections to multiple outputs 1
Automated Reports 0
Excelsend method inconsistent using Access 2003 and 2007 0
Excel not "letting go" after DoCmd.Transferspreadsheet (Automation) 3
Send snapshot to various addressees in Outlook 0

Top