Can I export to a specific worksheet page in Excel?

C

Connie

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?
 
K

Ken Snell [MVP]

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.
 
V

vbkoder

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

Need Help with Macro Security 1
Exporting Data to One Excel Workbook to Several Worksheets 2
Export Report to a Worksheet 1
Exporting pivot tables to excel 1
Exporting to Excel 2
How to get a FORMULA into Excel 4
Converting excel to PDF, single page converts to multiple HELP! 1
Combine multiple worksheets in one Workbook into one big worksheet 6

Top