merge all files in sub dirs

[Rolf]

Hi

I like to merge all data in all excel files in all sub dir''s to 1 big file.
( the data can be on scheet 1,2,3 ...... )

Can you help?

Regards

Rolf

 

[Anthony]

http://msdn.microsoft.com/en-us/library/cc837974.aspx

I used this as a starting point and simplified it for my own needs..

Regards

Anthony

 

[Eduardo]

Hi,
take a look to Ron web

http://www.rondebruin.nl/copy2.htm
http://www.rondebruin.nl/copy3.htm