Macro for Opening files and copy the contents of the File

[ravichandavar]

You might want to give a little more detail. Are all these files Excel files? Do you want to consolidate them in to a single Excel file (in one worksheet, or multiple worksheets)? Do you want to copy the entire content? Should the headers be copied all the time if they are available?

Hi,

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.

Regards,
Ravi.C