Macro to Export to Excel

[kimbobo]

I have a query with a field that has 118 different values. I need to
filter by each of the 118 different values and export the results into
separate excel workbooks.

I would love a macro that does this...but I only have written macros
for excel.

Any ideas?

Thanks!

-Kim

 

[Arvin Meyer [MVP]]

Have a look at the TansferSpreadsheet action in the Access help files. Write
a query for each filter. Choose the TansferSpreadsheet action in your macro
for each action and click a button to run it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access