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!