Try this example Zorro
http://www.rondebruin.nl/copy6.htm


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



"Zorro" wrote in message k...
I have a workbook with a around 40 worksheets in it. I would like to save each individual sheet to an individual workbook in a
named location hopefully following a naming convention, i.e: c\documents and settings\zorro\my documents\My
Project\workbookname_sheet1.xls, ...sheet2.xls, ...sheet3.xls etc.

Hope you can help


Zorro