Saving one sheet as a seperate file

  • Thread starter Thread starter Claud Balls
  • Start date Start date
C

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.
 
Activate the sheet. Click on Edit>Move the Sheet>Move to new book.

If you want the code. Record the above.
 
Worksheets("Sheet1").Copy
ActiveWorkbook.SaveAs Filename:="myFile.xls"

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Button to Save File as PDF 6
Help with copying a sheet from One workbook to another workbook 1
CONSOLIDATE DATA FROM MULTIPLE SHEETS IN ONE 1
Saving worksheet as a text file 7
How to "freeze" all cells in Excel sheets? 1
Right-mouse open a 2nd file to a particular sheet that correspondswith a 1st file's sheet 2
Save excel sheet as html then save to web useing ftp 1

Back
Top