Macro for Opening files and copy the contents of the File

[ravichandavar]

Hi Yes,

I did that but still its not working.One more thing Suppose my folder contain 3 or 4 files and from these files data from second file should come down the data's of first file subsequently 3d and forth.

For example: Files of the folder contains data in A1:T100 And i need to paste this in my consolidation file as A1:T100 contains first file data and A101 to T200 should take data from second file and so on...

Hope you might have understood my requirement.

Please find the attached file....