Hi,

I am working on a project which involves copying certain data from several
excel spreadsheets to a target excel spreadsheet. The source excel
spreadsheets are thousands in number and are formatted in a certain way so
that the cells can be specified for copying.

Opening and closing the source excel files is very tedious. Is there a way
to open an excel source file, copy the data to the target, kill the source
file and then repeat this process with the second source file till we
complete the entire set of excel source files using a macro?