Multiple Saving

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Please help...

I am trying to save one workbook into 2 separeate excel files.

I want to try and save one worksheet as one file and delete other sheets,
then go back to my original data report and save another worksheet as a text
file.

How is this possible??

Thanks,
Jez
 
Sheets("Sheet2").Select 'select which sheet to copy/save
Sheets("Sheet2").Copy 'copy it to a new workbook
ActiveWorkbook.SaveAs ... 'specify filename, etc to create the first new
workbook
ActiveWorkbook.Close
' now repeat for the next sheet; note that the source workbook is left
unchanged by the steps above.
 
File, Save As and then choose text file at the bottom - it will only let you
save the active sheet.
 
Back
Top