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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"bm4466" wrote in message
...

Hi,
Does anyone know of a way to merge multiple excel books that will be a
single sheet per book into one file - i can name them in any format and
they will all be in the same directory. Thanks, Ben


--
bm4466
------------------------------------------------------------------------
bm4466's Profile: http://www.excelforum.com/member.php...o&userid=33949
View this thread: http://www.excelforum.com/showthread...hreadid=542548