Output Report to Multiple XLS Worksheets

  • Thread starter Thread starter Anthony Viscomi
  • Start date Start date
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
 
Use 5 transfer spreadsheet actions in a macro
The sheet name will default to the report name

Jim
 
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...
 
Back
Top