Exproting Excel Worksheet to seperate Workbook
 

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

Exproting Excel Worksheet to seperate Workbook
 

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