Save worksheet

[jpen]

Hi all,

I have a workbook from which I save the active worksheet using savecopyas. The saved copy is sent in the same macro as a attachment with a email.

But now I only want to save the active worksheet and not the macro.

Any idea how I can do this?


JH

 

[Andrew Poulsom]

Have you tried copying the sheet to a new workbook (ActiveSheet.Copy) and saving that (ActiveWorkbook.SaveAs)?

 

[jpen]

No Andrew I will try it.

Thanks