Hi,

I get a sent a workbook that has around 100 worksheets in it.
is it possible to export all of these worksheets out to new files with
the name of each new file to be that of the worksheet?

Pete.