Rename Sheet on Transfer to xls

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

When I run this command:

DoCmd.TransferSpreadsheet acExport, 8, "Batch05", "C:\My
Documents\A-ExportBatch", True, ""

The worksheet in the created xl file will be named Batch05
when I want it to be named Sheet1. How can I get this
code to name the worksheet Sheet1.

Thank you,

Steven
 
Steve,

The last argument in your expression (empty quotes) are
for the Sheet name! Just end it with "sheet1" instead
of "" and you've got it.

Nikos Y. (nyannaco at in dot gr)
 
You must log in or register to reply here.

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

Export to Excel - Access 2013 to Excel 2013 0
docmd.Transferspreadsheet acExport 2
Create a file 2
Queries 3
expected format 3
Export Query Name 1
Transfer my query result to FTP ? 2
Export to excel 1

Back
Top