Hi Maaz

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

Or one of the other examples on my site


--

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


"Maaz" wrote in message ...
there is a folder containing 400 excel files which are on same pattern. I
want to merge all files in a single new excel file.