Outputting a report to Excel

[rj51cxa]

I have a command button which has the following code:

Dim oXL As Object, x
    stDocName = "RptSignatureSheet"

    Set oXL = CreateObject("Excel.Application")
    DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, "c:\zzz\signaturedata.xls", True

Having created the workbook, I now need to do the following:

1 Save this workbook as "signaturedata.xls".
2 Open file "TrophySigSheet.xls" which has links to "signaturedata.xls".
3 Update the links and close "signaturedata.xls"
6 Save "TrophySigSheet.xls"
6 Return to Access, leaving Excel running with "TrophySigSheet.xls" open

I have tried various code combinations to achieve this but am getting nowhere.

I would be most grateful if someone could please advise the code I should use.

Desperate John