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
 

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

Similar Threads

Exporting Data to One Excel Workbook to Several Worksheets 2
Export Report to a Worksheet 1
Exporting to Excel 2
Can I export a linked file to a specific excel worksheet? 3
Exporting pivot tables to excel 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Exporting separate query results to same workbook diff worksheets 2
How to get a FORMULA into Excel 3

Back
Top