exporting excel sorted

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.
 

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

VBA - exporting serial letters to single documents 0
Export Report with Graph to Excel error 2495 1
Cannot sort a table containing text 5
Exporting from MS Access to a protected spreadsheet 1
Date Parameter on export 3
expected format 2
Pasting a cell into bookmarked table from excel vba 1
Saving Excel from Access 1

Top