Can I export to a specific worksheet page in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Office 2000 and want to export multiple tables sequentially (via a
macro) into multiple worksheets in one workbook. One note said it was OK for
Excel Version 5 and above (not sure what version that is!). And it doesn't
tell me the syntax for how to do that in my macro.

Any hints?
 
If you export the tables to the same EXCEL workbook, ACCESS will create a
new worksheet within that file for each table. No special information or
syntax is needed.
 
Ken,

I am not sure I agree with you on this. When I export a spreadsheet from
Access to Excel 2003 and then export a new table's information to the same
file, it writes over the old data and does not create a new worksheet. Is
there some special syntax or something I need to use?

Thanks,

Dave
 
Back
Top