I have a workbook with multiple sheets (one for each month) which is a
rather large file.

I'm trying to find a way to save only the current worksheet to a file
(i.e., eliminate all sheets but the current one).

I've tried ActiveSheet.SaveAs (ActiveSheet.Name), but this saves all the
sheets.

Is there a way to do this.

Export your worksheet to another workbook and save them.


-----Original Message-----
I have a workbook with multiple sheets (one for each
month) which is a
rather large file.

I'm trying to find a way to save only the current
worksheet to a file
(i.e., eliminate all sheets but the current one).

I've tried ActiveSheet.SaveAs (ActiveSheet.Name), but
this saves all the
sheets.

Is there a way to do this.
.

To do it manually:

rightclick on the worksheet to save, select "move or copy".
make it go to a new workbook
(and choose copy at the bottom)
Save that new workbook.

If you need a macro, record it when you do it manually once.



Jerry Park wrote:

I have a workbook with multiple sheets (one for each month) which is a
rather large file.

I'm trying to find a way to save only the current worksheet to a file
(i.e., eliminate all sheets but the current one).

I've tried ActiveSheet.SaveAs (ActiveSheet.Name), but this saves all the
sheets.

Is there a way to do this.

--

Dave Peterson

Dave Peterson wrote:
To do it manually:

rightclick on the worksheet to save, select "move or copy".
make it go to a new workbook
(and choose copy at the bottom)
Save that new workbook.

If you need a macro, record it when you do it manually once.



Jerry Park wrote:

I have a workbook with multiple sheets (one for each month) which is a
rather large file.

I'm trying to find a way to save only the current worksheet to a file
(i.e., eliminate all sheets but the current one).

I've tried ActiveSheet.SaveAs (ActiveSheet.Name), but this saves all the
sheets.

Is there a way to do this.


Thanks