Export to Excel with Named Sheet

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

Guest

I have the following code in one of my report events:

DoCmd.OutputTo acReport, stDocName, acFormatXLS, "P:\Filename.xls", False

It works like a charm, except for one thing. When I open the file in Excel,
it give me an error message for each line indicating that I used an invalid
sheet name, and it re-names the sheet, "Recovered_Sheet1". Is there
something I can add to the code above that will produce a valid sheet name,
and then dump the data into a sheet with that name?

I am still in the dark ages with Access 97 (it talks with our legacy
databases), even though we have Office 2003 for Excel and Word.
 
Did you try the TransferSpreadsheet method. This may give you better results.

The format is

DoCmd.TransferSpreadsheet [transfertype][, spreadsheettype], tablename,
filename[, hasfieldnames][, range]

You can get more detailed in the help file. I use this all the time without
any problems.
 

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 to Excel, Set Sheetname 3
Renaming Excel Worksheet Names after creation in VBA 5
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Transfer 2 querys to the excel workbook but to different sheets 1
Invalid Sheet Name on Export 1
How can you generate an Excel file from a query that has parameter 4
Export to Excel 1
Export SQL stored procedure to Excel file 1

Back
Top