You can try
http://www.rondebruin.nl/copy6.htm


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


"Emece" wrote in message ...
I have one workbook with 15 sheets. I want Excel to generate one separate
workbook from each sheet in the book. Is this possible?

Thanks in advance

Regards,
Emece.-