Append rows from Access table to first empty row in Excel

Hi,
I am trying to export a table from Access to the end of an existing range in Excel.

here's what I have so far;

        Set objXL = New Excel.Application
            With objXL
                Set objWkb = .Workbooks.Open(GetMyPath() & "Call_Offs.xlsm", , , , "password")
                DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryUpLoadOrders", GetMyPath() & "Call_Offs.xlsm", False
                objWkb.Save
                objXL.Visible = True
                For Each WS In objWkb.Worksheets
                    WS.Visible = xlSheetVisible
                Next WS
                objWkb.Worksheets("Loading").Activate
                AppActivate objXL.Caption
                Set objWkb = Nothing
                Set objXL = Nothing
            End With
        Exit Sub

Select allOpen in new window

If I put a named range at the end of the "transferspreadsheet" line it just overwrites the existing data.

I'm looking to tag the table rows onto the end of the existing data starting in column A in the sheet called "Orders" of the "Call_Offs" workbook, then clear the data in the MS Access Orders table ready to accept new orders next time.

As usual all help is appreciated.