DoCmd.OutputTo question

[mkc80]

Can you specify a sheet name in the DoCmd.OutputTo command when trying to export multiple reports to multiple sheets in the same excel file?
If yes, what is the syntax?

[June7]

No, cannot. Nor does DoCmd.TransferSpreadsheet allow that.

[mkc80]

Sorry, my question was, Can I direct output from multiple reports to multiple sheets in a Excel workbook?

[June7]

Still, no. Each output will be to a new file.

[zane]

Still, no. Each output will be to a new file.

uummmm, still YES. mkc80....use teh docmd.transferspreadsheet option. Create ranges in Excel (ie in the different spreadsheets you want to output to) and the data will be exported to those ranges.

super moderator???
pffff

[June7]

I didn't pick the title 'Super Moderator' (suppose I could change it) - it was given to me along with permissions to manage all threads on forum. Title doesn't mean I know everything. I still learn a lot here everyday.

Think I learned about using named ranges sometime after this thread posting and tested but didn't go well.

Also, OP wants to export report, not table or query.