export sheets to multiple new files

  • Thread starter Thread starter Tanya
  • Start date Start date
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
 
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
 
Worked exactly as I hoped. Thanks for the hours you've saved me! You make
this look so easy! --Tanya
 
Back
Top