Exporting to excell help

[stevanb]

I know this is complex but I am looking to streamline a weekly task.
I currently have 3 queries that export individually with one command button.
I then go and open each excel document and past it all into 3 different tabs
in one doc. I am looking to be able to press this one command button and have
the three queries exported into the already created document into each tab
into a certain range.

The reports are called ADMIN, TAD, and X-DECK and the tabs correlate to them.
The range is going to be to inserted as normal at the 3rd row instead of the


1st.

Looking to use a VBA code if anyone has some suggestions

Thx for all the help

[ssanfu]

There is a site
Ken's ACCESS Tips, Code Snippets, and Other ACCESS "Things"

main url: http://www.accessmvp.com/KDSnell/default.htm

that has a lot of examples of how to export to EXCEL using VBA:

http://www.accessmvp.com/KDSnell/EXCEL_Export.htm

I used this reference a lot for my code....