Need of exporting module - qry to particular sheet in Excel book

[01491]

I need somehow to export a query onto a particular sheet in an Excel workbook. This is because I want to export a different query onto a different sheet in the same workbook.
I have enclosed the code so far: any help be much appreciated!!!
Sub Export()
DoCmd.TransferSpreadsheet acExport, 8, "QryNullInputbyKeyprocess", "K:\RiskMan\Risk Review\JohnA\Risk Mapping Tool\RAP Output.xls.", True
End Sub

 

[hilbertl]

All you need to do is change the query name while keeping the same file name. A second worksheet will automatically be created in the same workbook.

hth,

Hilbert