Hi everyone. My goal with this question is to learn to transfer multiple queries (crosstab queries in Access 2002) to a single excel spreadsheet.

I thought of using the Do.Cmd.TransferSpreadsheet acExport command in the VB code of Access, but I soon realized that I couldn't identify where the data would be put specifically into a particular cell of the spreadsheet.

Hence, my thought process is telling me that if I'm able to sendout the crosstab queries to different tabs within a single spreadsheet, I can then have a master tab in that spreadsheet calling the values from the outputted tabs, thereby simply filling in the blanks that I need for my report in MsExcel.

An example of what my excel spreadsheet (report) would contain/show is as follows:

Total # of Customers-------------------------Loc1-----Loc2-----Loc3
454-------------------------------------------300------105------49
Customers Serviced within the last 30 days
322-------------------------------------------180------102------40
Customers Serviced past 30 days
132-------------------------------------------120------003------9

Where...
-Total # of Customers
-Customers Serviced within the last 30 days
-Customers Serviced past 30 days
... represents an individual query (3 queries total). And the Loc1, Loc2, and Loc3 are the 3 different locations from which we do business (also from the same queries).

Thanks in advance for your support guys.

~Danny

__________________
~Danny

does anyone know the vba code to sendout data to a particular cell of excel instead of the entire query to a 'tab' in excel?

~Danny

This will get you there....

    Set appExcel = New Excel.Application
    Set wbkNew = appExcel.Workbooks.Add
    Set wksNew = wbkNew.Worksheets.Add
    appExcel.Visible = False

    'Make Column Headings
    With wksNew
        .Cells(1, 1).Value = "(Your Data)"
    End With


John