Exporting Access Information into Multiple Excel Tabs Using a Macr

  • Thread starter Thread starter rano126
  • Start date Start date
R

rano126

I have set up a macro to export a bunch of different queries to excel. Is
there a way to have those 6 different queries export to different tabs in the
same worksheet. I can only get it to export to different workbooks.
 
Rano,

By "different tabs in the same worksheet", I can only suppose you mean
different worksheets in the same workbook. Yes?

You can't do this using the OutputTo action. But with
TransferSpreadsheet action, you can achieve this by an entry in the
Range argument, using this syntax:
Sheet1!A1:A1
 
Steve Schapel said:
Rano,

By "different tabs in the same worksheet", I can only suppose you mean
different worksheets in the same workbook. Yes?

You can't do this using the OutputTo action. But with TransferSpreadsheet
action, you can achieve this by an entry in the Range argument, using this
syntax:
Sheet1!A1:A1
Click to expand...

Or, more preferably, by exporting differently named queries in the macro.
Each unique query name will go to a different worksheet in the workbook.

See Alex Dybenko's blog about how the undocumented Range argument in
TransferSpreadsheet sometimes can be used to control writing data onto
existing worksheets:
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html
--

Ken Snell
<MS ACCESS MVP>
 
Back
Top