Exporting table to a specific folder?

[gllegend]

Does anyone know how you would export a table to a specific folder? I am trying to go to a specific period, 1-13 and day, tuesday or friday. thanks for your help in advance

 

[Norie]

Can't you just navigate to the folder when you goto File>Export...?

 

[VicRauch]

Do you mean Export as to a text file, or are you going to an Excel spreadsheet? If going to Excel, you could use the DoCmd.TransferSpreadsheet command and do it in code. If you really want Export, then just navigate to the folder as Norie suggested.