Combining a few hundred excel files into one
 

Hi,

I have tried a few macro codes for merging several similar excel files
into one but all of them (the ones that actually worked) did not read
the 'correct' worksheet withing the XLS.

Can anyone give me a hint?

Thank you so much!!!

Alex

Combining a few hundred excel files into one
 

Start here
http://www.rondebruin.nl/copy3.htm

Try the add-in if you want it simple

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
Hi,

I have tried a few macro codes for merging several similar excel files
into one but all of them (the ones that actually worked) did not read
the 'correct' worksheet withing the XLS.

Can anyone give me a hint?

Thank you so much!!!

Alex