Saving Individual Tabs as Files

For beginners, Record Macro is your new best friend. I'd give that a shot.

1. Just goto Tools-->Macro-->Record New Macro...
2. Click OK
3. Do whatever it is you're wanting to do (in your case, just save one of the sheets as a different workbook)
4. Click the stop button (just like on a VCR)

To see the code you just recorded, hit ALT + F11 and expand the Modules folder on the left. In it should be "Module1", where your code is located.

Just double-click on Module1 and there it is.

I hope that helps!

The following cod will copy the active sheet to a new workbook

Please Login or Register  to view this content.

hi Don,

You should find the below link useful:
http://www.mvps.org/dmcritchie/excel/saveas.htm

I found the above using this google search: http://www.google.co.uk/search?hl=en...meta=&aq=f&oq=

StarryKnight, I agree that recording macros can be a beginners best friend & a recorded macro does provide the basic bones of what the OP has asked, but in this case, to revise it into a looping macro ("for each tab") is likely to be above their immediate abilities. So I would add number 5 to your list as something along the lines of "review the resulting code & make it more generic by changing hardcoded strings to variables etc" & 6...
However, thanks to the wizzes, a ready made solution already exists

hth
Rob

Something like this should split each sheet to a separate workbook

Please Login or Register  to view this content.

ailenetg welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

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.

No problem, we all have to start somewhere