Tom want to copy this link I think
http://www.rondebruin.nl/copy3.htm

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


"Tom Ogilvy" wrote in message ...
http://www.rondebruin.nl/copy5.htm

has a bunch of code you can probably adapt to your requirement.

--
Regards,
Tom Ogilvy


"Ian Mason" <Ian wrote in message
...
Unable to merge multipal workbooks into one wokbook, any idears?