Brian Thompson via OfficeKB.com
Guest
Re: macro to save new file (same as tab name)
Hi Bob
Will save workbook in usual way. then will copy sheet, paste special, format
and then save as the tab name. This new sheet(wkbook) will then be sent via
mail.
The last line does work, however, only keeps saving "sheet3"
What do I replace "Sheet3" (see below) with to save selected sheet I am
veiwing at the time
Sheets("Sheet3").Select
Range("A1").Select
ActiveWorkbook.SaveAs Filename:=ActiveSheet.Name
thanks for your patience !
regards
Brian
Bob Phillips wrote:
>What exactly do you mean by save the sheet? Normally, one saves a workbook,.
>a sheet is part, but not all , of a workbook.
>
>--
>
>HTH
>
>Bob Phillips
>
>(remove nothere from the email address if mailing direct)
>
>> thanks, it worked, however, I do reqiure to save the acutal sheet the i'm
>> viewing. In the example below i was in sheet3.
>[quoted text clipped - 26 lines]
>> >>
>> >> brian
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200601/1
Bookmarks