Output to macro action



In Access 2003 when you used the transfer spreadsheet action on a table, and
transferred to Excel, the table would appear as a worksheet. If you
transferred another table, using the same excel workbook file name, the
second table would appear as a worksheet in the same excel workbook.

When I used output to in Access 2007, the table outputs to an excel
workbook. I have not been able to determine how to have multiple tables
output to the same workbook as different worksheets.

Any ideas

Steve Schapel


I am not sure about this specifically, without testing. But you are talking
about 2 different macro actions here: TransferSpreadsheet and OutputTo. Can
you please check your requirements with both actions?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question