Exporting to Specific Excel Worksheet

A

alex richardson

For Access exports to regularly update a specific
worksheet within an Excel spreadsheet, is there a way to
overlay the current worksheet rather than appending a new
worksheet?
 
N

Nikos Yannacopoulos

Yes! That's what TransferSpreadsheet does, if you use the Range argument to
specify the worksheet name - although Access help says this argument is not
used in export.

Nikos
 

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

Embed the same Excel multiple times 0
Using Office Forms and dynamically updating the excel backend 0
Integrating information from Word to Excel (not mail merge) 1
VBA to do a mailmerge from a Specific Excel worksheet 0
Export Report to a Worksheet 1
Exporting to Excel 1
Exporting Data to One Excel Workbook to Several Worksheets 2
Export Query to Excel 1

Top