Output Report to Multiple XLS Worksheets

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
 
J

Jim/Chris

Use 5 transfer spreadsheet actions in a macro
The sheet name will default to the report name

Jim
 
A

Anthony Viscomi

I beleive that this method only works for tables
Jim/Chris said:
Use 5 transfer spreadsheet actions in a macro
The sheet name will default to the report name

Jim
Click to expand...
 

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

Automate an output of a report 1
Output to macro 1
Hiding a Field on a Report 1
Macro to run the same report for muliple users 1
Linking an Excel XLS in Access 97 2
Automate Worksheet 9
Output to Outlook express problems 1
Macro to 'Analyze in Excel' 2

Top