Exporting table to a specific folder?

gllegend

New Member
Joined
Oct 25, 2006
Messages
1
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
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,911
Office Version
  1. 365
Platform
  1. Windows
Can't you just navigate to the folder when you goto File>Export...?
 

VicRauch

Well-known Member
Joined
Mar 23, 2006
Messages
2,032
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,542
Members
410,549
Latest member
Anaarchie
Top