Split worksheets to separate files

**ksteffin** · 02-25-2011, 11:51 AM

Hello all. I am working on a project that is two part. I am working with Excel 2007. I have a workbook that has 50 or so worksheets that I need to split and save as individual files. I found the following code online. It works fine, however, I need the "new" workbooks to be saved as Excel 97-2003 files. What do I need to add to this to make that happen?

Please Login or Register  to view this content.

Part Two is this: I have another file that I'm needing to split as well. However, the information in this workbook is organized in a Pivot Table. I have utilized the 'Show Report Filter Pages' to have the information on separate worksheets so that I can split the file. Will the above code (with the modification to save in 97-2003 format) work with the Pivot Table?

**aravindhan_31** · 02-26-2011, 04:37 AM

Try

Please Login or Register  to view this content.

change this to

Please Login or Register  to view this content.

**ksteffin** · 03-22-2011, 11:14 AM

That works great! One more question. The original workbook contains reports that I need to split and send out each month. If i wanted to add "March Reports" to the sheet name only when saving it, how would I do that? Could I add "March Reports" like this?

Please Login or Register  to view this content.

Thanks for your help, aravindhan_31!

**Sonam Sahani** · 10-10-2013, 06:02 AM

I tried using this macro, however while opening the splitted worksheet I am getting the error"The file you are trying to open, " ", is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file" , whereas the original file which I am trying to split is also in .xls format. I do not want this error. Please help

**Fotis1991** · 10-10-2013, 06:04 AM

Sonam Sahani

Unfortunately you have to start your own thread for this.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.