View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Anthony[_18_] Anthony[_18_] is offline
external usenet poster
 
Posts: 18
Default 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