Exporting 2 queries into 1 excel spreadsheet

[Guest]

I have a form which processes/creates 2 queries, "Category Query" &"Project
Query" and opens them up. I want this same button to export both these
queries into one excel spreadsheet. I want them both to be displayed in one
worksheet, one above the other. They both contain the same amount of columns,
so allignment will not play an issue in this. I also want an option of where
to save the excel spreadsheet and what to save it as. Hopefully I am able to
do this.
Thanks to those who can help.

 

[[MVP] S.Clark]

UNION the queries together, then export.

Select * from tablename

UNION

Select * from tablename

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html