Exporting to a specific worksheet and overwrite exiting data

[JD]

I have a query that compiles historical data. I want to export it to an excel workbook name Historical.xls. I want the dat to go in worksheet rawdata. How do I export to rawdat and overwrite the old data

Thank
JD