Saving one sheet as a seperate file

[Claud Balls]

I have a macro that performs some calculations, and records specific
data to a sheet. I then open save the information from that sheet to a
text file. I would like to know how to save the data to an excel file,
rather than a text file.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[gocush]

Activate the sheet. Click on Edit>Move the Sheet>Move to new book.

If you want the code. Record the above.

 

[Bob Phillips]

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

--

HTH

RP
(remove nothere from the email address if mailing direct)