Need some macro

[Ron99]

Hi,

I have a folder name (project) in my C drive. These folder contains 40 excel spreadsheet, each excel sheet has two tabs or three tabs of data.

What I want to do is, I need a masterfile and I want to consolidate all the data from each and every excel spreadsheet to one masterfile.

Can you please help me in sending the code.


Regards,
Ron...

 

[VoG]

This should help you http://msdn.microsoft.com/en-us/library/cc837974.aspx

 

[Ron99]

Thank you for the link, but it dint help me much, the code is not copying the data from all tabs. It just copies first tab but not all data.

Any other code ?

Regards,
Ron...