export query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I export more than on query into one excel worksheet. ie.

query1 from cell a1 to n6 in worksheet A
query2 from cell a9 to n16 in worksheet A (same one on same file)
 
When you export into excel, each export is into a unique tab.

It is possible then from within access to open up excel, and then go to
that second tab, select the desired range, copy it, then go to the
first tab, go to the desired cell and paste it in.
Then save and close the spreadsheet.

Frequently, I will go into the spreadsheet, and make a macro that
details all the steps I want to do, then copy and paste it into the
access module and make the modifications necessary to do it from
access. For me it seems that roughtly 90% of the things I can do in a
macro in excel I can also do as vba code from access.

Ron
 
Back
Top