Macro Export to Excel Question

[Andrew]

Hi,

I hope someone will be able to provide me some help. I
have 70 or so School Codes (SC) that need to go from a
query in Access to Excel. The desire is to have each IC
be on a different tab within the same workbook. I can
run one query 70 different times as my Access query
prompts me for the SC & export each time, or I can copy
the one query 70 times and have one specific query for
each specific SC, or I can run one query that puts all 70
SC's on one tab in Excel, and then figure out how to get
Excel to take the data and separate it onto different
tabs.

What I currently have is Crosstab Query Revenue, Crosstab
Query Style, Crosstab Query Cars, Select Query RevWgt,
and Select Query RevWgtCar.
Select Query RevSty combines Crosstab Queries Revenue &
Style.
Select Query RevStyCar combines Select Query RevSty and
Crosstab Query Cars.
This gives me 3 values (Revenue, Style, # of Cars) in a
crosstab format (SC and CountyOrigin is row, SchoolArea
is Column). This data needs to be exported to Excel and
the data is comprised of 70 or so unique SC's that make
up approx. 300 records (Some SC's have more than related
record). The desire is for each SC to be on a separate
tab in the same workbook. I have 2 macros that export
the Select Query RevStyCar to Excel: one uses the
action "TransferSpreadsheet" and the other macro uses the
action "OutputTo."

Thanks in advance.

Andrew