I am using:

to successfully export some records to Excel. My question is, can this technique be used to export data to an Excel workbook that already contains spreadsheets (with macros) without clobbering the existing data?

If so, please explain in detail.
If not, can you suggest an alternative method?

Thank you.

Thanks anyway, but I figured it out:

If you put the target spreadsheet as the 1st spreadsheet in the workbook, the other sheets are not overwritten.