I some code where I transfer info from Access to an Excel Spreadsheet
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, stDocName, strFileNameL (stDocName is the query to be exported, and strFileName is the name of the spreadsheet)
I now want to transfer this same information to an existing spreadsheet, that has other sheets in it and I don't want to delete the file, but just insert it into the file.
Is there a way to accomplish this?
thanks in advance for your consideration.