Saving one sheet as a seperate file
 

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!

Saving one sheet as a seperate file
 

Activate the sheet. Click on EditMove the SheetMove to new book.

If you want the code. Record the above.

"Claud Balls" wrote:

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!

Saving one sheet as a seperate file
 

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

--

HTH

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


"Claud Balls" wrote in message
...
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!