Separating a documents worksheets into individual documents

I have was given a document with 87 worksheets . Each worksheet needs to become individual document.

Does anyone have a quick way to do this?

Perhaps also separating each file into the 87 already created folders of the same name as the worksheet. I've got to put them in their respective locations. This doesn't take long manually, so it's a low priority.

Wow, I really need to proofread the subject line before I submit.

EDIT: refering to the subject of this post. "Separating a documents worksheets into individual documents" almost engrish.

Hi CWinkler

I just looked at your Thread...what have you discovered?

Hi CWinkler

This is relatively easy

Each worksheet needs to become individual document

dangelor has suggested code to do the same. However, the code does not check for this

already created folders of the same name as the worksheet

So, I'll ask again

Wow, I really need to proofread the subject line before I submit.

what have you discovered?

Originally Posted by dangelor

Quick and dirty... will save each worksheet to a separate file.

Please Login or Register  to view this content.

Oh yes, I did find that same code. And it works, but unfortunately, I'd like to append that worksheet filename with a specific path and text.

IE. save as "Folder/Some Text Worksheet Name.xlsx"

And actually, the code above doesn't work. It basically copies the entire workbook and saves it as the worksheet name active in the FOR loop.

I did figure out that the string inside the parenthesis requires the "+" operator and not the "&" operator, Which is frustrating. IE: ws.SaveAs (ws.Name + "more text")

Why isn't it just saving that particular worksheet?

Took a new approach.

Gathered the basic code from this post
http://www.ozgrid.com/forum/showthread.php?t=53353

Please Login or Register  to view this content.

The folders already exist so I don't need to check for them or create them, so that simplified things.