Macro for Opening files and copy the contents of the File

[Rick Rothstein]

Yes all files are excel files, and i want a consolidated data in one worksheet including the Headers.i.e all contents of the files.

1. Is the structure for each file identical (same headers in the same order)?

2. Do all the files consist of only a single worksheet each?

3. Is the order the files are consolidated in important (in other words, is the final order of the data important)?

4. The Headers... are the all on Row 1 only?

[ravichandavar]

1. Is the structure for each file identical (same headers in the same order)?

2. Do all the files consist of only a single worksheet each?

3. Is the order the files are consolidated in important (in other words, is the final order of the data important)?

4. The Headers... are the all on Row 1 only?

Hi Rick,

Yes,all the points you mentioned above is right.

Regards,
Ravi.C