may somebody help me please.
I need to export my report to excel
I use docmd.outputto, the result is oke, but it only write to single sheet, it can repeat to sheet2 sheet3 etc.
I use docmd.transferspreadsheet, it cannot work if the source to export is report. It only work if the source is table.
Do I wrong...?
My focus is, write to same xls file to multi sheet in that xls file.
For example, i have 5 report in access, need to export to destination.xls to sheet1 sheet2..... sheet5.
Please help me
Thanks very muccccchhhhhh
I need to export my report to excel
I use docmd.outputto, the result is oke, but it only write to single sheet, it can repeat to sheet2 sheet3 etc.
I use docmd.transferspreadsheet, it cannot work if the source to export is report. It only work if the source is table.
Do I wrong...?
My focus is, write to same xls file to multi sheet in that xls file.
For example, i have 5 report in access, need to export to destination.xls to sheet1 sheet2..... sheet5.
Please help me
Thanks very muccccchhhhhh