Hello
I have built a report within access that will output every record to an individual excel file per record.
the specific report has two sub reports (3 layers) in total so the excel file output results in grouped format.
However, the end user wants all of the records in one Excel Workbook, and each record to be specific to a sheet.
For example
currently it will creat a workbook per number.
1.xls for ID = 1
2.xls for ID = 2
3.xls for ID = 3
however, they would prefer Month.xls
with 1 for ID = 1 in sheet 1
with 2 for ID = 2 in sheet 2
with 3 for ID = 3 in sheet 3 etc
is it possible to output to one excel file and then to specific sheets?
some of these workbooks will have upto 30 sheets if it is possible.
many thanks in anticipation
Donna
I have built a report within access that will output every record to an individual excel file per record.
the specific report has two sub reports (3 layers) in total so the excel file output results in grouped format.
However, the end user wants all of the records in one Excel Workbook, and each record to be specific to a sheet.
For example
currently it will creat a workbook per number.
1.xls for ID = 1
2.xls for ID = 2
3.xls for ID = 3
however, they would prefer Month.xls
with 1 for ID = 1 in sheet 1
with 2 for ID = 2 in sheet 2
with 3 for ID = 3 in sheet 3 etc
is it possible to output to one excel file and then to specific sheets?
some of these workbooks will have upto 30 sheets if it is possible.
many thanks in anticipation
Donna
