Export To Excel and Save Formatting

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

Guest

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?
 
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...
 
Back
Top