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