Export Access Query to an existing excel file specifying range

[aga2957]

Hi Guys!

Here's what I'm trying to do.

I'm trying to export one of my queries to an excel file. But the thing is, that excel file is preformatted already and I only want to transfer the result to a specified range which is the source data of one of the graphs in the excel file.

I did this command:

DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel9, "Query1", _
"C:\sample.txt", , "A1:A10"

but I am receiving an "existing range".


Any thoughts?