Hi Dave

Yes you can use this macro to do this
http://www.rondebruin.nl/copy6.htm

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



wrote in message ups.com...
I have a workbook that has about 100 different worksheets in it. Is it
possible to export each worksheet to its own work book? I would like
to name each workbook the name of the sheet it contains.

Thanks,

Dave