exporting excel sorted

  • Thread starter Thread starter Jim Hill
  • Start date Start date
J

Jim Hill

Hello,
I use "DoCmd.TransferSpreadsheet acExport, 8, myTable,
myFile, False, """ command in a module to export the table
to an excel file. In the table there is a date filed and
it is sorted by date but the file does not come up sorted
by date. How can I keep the same sort option while
exporting the data.
Thanks,
Jim.
 
Back
Top