export sheets to multiple new files

T

Tanya

I have a workbook with several worksheets (30) and am trying to find a way to
save each worksheet in the book as a new excel file using the name of the
worksheet as the new file name...I use the move or copy regularly, but was
hoping to avoid having to type the names for each worksheet inorder to save
them?

Thanks for your help!

Tanya
 
R

Ron de Bruin

Hi Gord

I have it set a xlsm because most of my files have code
And a lot of people have it set to 97-2003

For others here you can change it in 2007 if you want
Office Button>Excel Options...Save
Change "Save files in this format .............."


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
 
T

Tanya

Worked exactly as I hoped. Thanks for the hours you've saved me! You make
this look so easy! --Tanya
 
Top