Hi,
I have three crosstab queries that needs to be placed at the different
ranges in the same excel sheet .
How can I achieve this with do.cmd.transferspreadsheet.

Dim strQName As String
strQName = "7a-query"
Dim strNewName As String
strNewName = "c:\file.xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, strQName,
strNewName, True

I have the sample code here.
Now, how can I put the second query(which is 7b-query) on the same
tab,"7a-query" at the range, G2?
Thanks,
Prasanna.