Export To Excel and Save Formatting

M

mroby

I have a database In which I am exporting a table to Excel using

DoCmd.TransferSpreadsheet acExport, 8, "tblExport",
"C:\Burn\TestExport.xls", True, ""

If I export this manually I can click the 'Save Formatting' button and all
works well. How do I add this addtional feature into my code above?
 
J

John Nurick

Try using DoCmd.OutputTo instead.

I have a database In which I am exporting a table to Excel using

DoCmd.TransferSpreadsheet acExport, 8, "tblExport",
"C:\Burn\TestExport.xls", True, ""

If I export this manually I can click the 'Save Formatting' button and all
works well. How do I add this addtional feature into my code above?
Click to expand...
 

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 Report with Graph to Excel error 2495 1
VBA - exporting serial letters to single documents 0
Export Access pivot table to Excel 0
Add Date to export file Name 1
Problems Exporting a table 0
Prompt for file location Export to Excel 3
Exporting to an excel template file 0
Problem exporting multiple tables into different worksheets in oneworkbook 3

Top