merge all files in sub dirs
 

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

merge all files in sub dirs
 

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

"Rolf" wrote in message
...
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

merge all files in sub dirs
 

Hi,
take a look to Ron web

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

"Rolf" wrote:

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



.