Hi there,

I have three Access 97 tables that I am trying to export Excel fro
VBA. The problem is I would like all three to be on the same workboo
rather than on different workbooks (i.e., having one workboo
containing three tabs each for a differnt table data)

The code I am using right now which creates three different workbook
are as below:

DoCmd.OutputTo acQuery, "Table1", acFormatXLS, "C:\Data\Table1.xls"
True

DoCmd.OutputTo acQuery, "Table2", acFormatXLS, "C:\Data\Table2.xls"
True

DoCmd.OutputTo acQuery, "Table3", acFormatXLS, "C:\Data\Table3.xls"
True

I would very much appreciate all suggestions and help!!!

Thanks,
chill

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements