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.
.