How to export several queries to excel each having their own tab

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Emily F

    How to export several queries to excel each having their own tab

    In the Macro section of access there is "OutputTo" action which will export a query to it's own spreadsheet in excel -What I need, is a macro (if it exists-but I think it will have to be created using VBA Code?)that will export several queries to an existing excel spreadsheet to their own individual tabs within that spreadsheet - its basically like going to each query I have and right clicking, choosing export then choosing where to export (which would be my existing spreadsheet
Working...