** Urgent Help ***Exporting one table to Multiple Excel Spread She

[Guest]

All,

I have a table that has Multiple account types, I need to export these into
seperate excel spread sheets to send the different departments. I tried
using Marcos and placing a condition but that does not seem to work (and I
dont understand Macros very well either).

I have a plethora of data and to export it to one spread sheet and cut and
paste will take me a month of sunday's.

Please any and all help is appreciated

 

[John Nurick]

Create several queries, one per department, each returning the records
for that department.

Then use TransferSpreadsheet to export each query to the same Excel
file, passing the name of the department as the Range argument each
time.

If the name and location of the exported file is always going to be the
same, you could just create a macro containing the series of
TransferSpreadsheet actions. If you need to be able to specify the
filename each time, put a textbox on your form (create a form if
necessary) and set up the TransferSpreadsheet macro actions to get the
filename from there. For example, if the form is called frmExport and
the textbox is txtFileSpec, you'll need this for the File Name argument:

=[Forms]![frmExport]![txtFileSpec]

Fancier solutions are possible, but they require you to write VBA code.