Save single worksheet from workbook using the sheet name?

A

Ajay

Gday,
I have had a search through some of the previous questions and I cant quite
find what I am looking for,
I have a master sheet which I split into seperate sheets using one of Debra
Dalgleishs macros all works fine.
However my next step is to save each of these sheets into seperate folders
using the individual sheet name.
As ever I hope this isnt too muddled a question!
Any help would be greatly appreciated
TIA
Ajay
 
B

Bob Phillips

Ajay,

You need to copy it to its own workbook and save that


Worksheets("Sheet1").Copy
ActiveWorkbook.SaveAs Filename:= "myfile.xls"


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top