"sharman" wrote:

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?



Certainly achievable using VBA but the specific code depends on how the data
to be copied out is structured, if the data structure differs between
workbooks and where the data is to be pasted in the main workbook.