Export from active worksheet to closed workbook

Under certain circumstances, yes. You can use ADO to export data from the activeworkbook to a sheet in a closed workbook as long as that destination workbook has headers, and as long as you include a header row in the source that you export from. For example:

Please Login or Register  to view this content.

Note that there is a memory leak issue with using ADO on an open workbook, but as long as you only run one or two exports at a time (and then close Excel) it shouldn't be a problem.