Exporting To Excel

[Dave31]

I have looked through the forum, and cant seem to find the answer. What i want to do is export all my tables to 1 excel spreadsheet.
Im using the code

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "workProductTable", "C:\Documents and Settings\My Documents\My Tool\Releases\imp\workProductTable", True

so this will save my workproducttable table to excel, but i want all my tables to be save in that one excel file

Any ideas how?

Mnay thanks

 

[Dave31]

also, when i export a table ("workProductTable"), a new table appears in my table list called workProductTable_ExportErrors.

Any ideas on how to prevent this table appearing if there are errors?