docmd.outputto vs docmd.transferspreadsheet (1 Viewer)

like

New member
Local time
Today, 15:33
Joined
Nov 3, 2006
Messages
6
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
 

Users who are viewing this thread

Top Bottom