Saving each worksheet as a separate file (starting from a particular worksheet)

Hey guys,

I'm pretty new and would love some input. Essentially I'm looking for a macro that will save each worksheet as a separate workbook. The trick is the number of worksheets will be a variable and I need to start from a particular worksheet. I'm working from a workbook that has the first four sheets as generic summary data info and, beginning on the 5th sheet, individual employee performance data. So, Starting from the first employee sheet to the last, however many there are, I need to save each as a separate file so that it can be sent as an attachment to that employee. I thought maybe filling an array with the worksheets and then referring to each element in the array from 5 to Ubound, and using saveas.....unfortunately im not skilled enough yet to completely hammer this out on my own.

Please Login or Register  to view this content.

Awesome man thanks! one thing, im gettin a 'subscript out of range' error @ wbNew.sheets(j).delete. Any idea?

Nice catch Andrew. Change is in red. You have to go from the back to the front when deleting the sheets. I didn't catch the error when I tested, because I have the option set to only create ONE SHEET, when Excel creates a new workbook.

Lewis

Try this:

Please Login or Register  to view this content.