Good afternoon Group,

Would somebody please tell me the VBA to :

Copy the worksheet to a new book -by creating it-
then save it as the cell "B1"
on "C:\Files"

All assitance on this subject will greatly help me with my daily labors,

Thanks in advance and greetings

Leo Rod
MIA-FL USA

I just recorded this. See cleaned up below

Sub Macro11()
'
' Macro11 Macro
' Macro recorded 8/28/2008 by Donald B. Guillett
'

'
Sheets("Sheet2").Select
Sheets("Sheet2").Copy
ActiveWorkbook.SaveAs Filename:="C:\files\mynewBook.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False
End Sub

sub copyshttonewwbandname()
activesheet.Copy
ActiveWorkbook.SaveAs Filename:="C:\files\" & range("b1") & ".xls"
end sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Leo Rod" <no spam> wrote in message
news:ew34vdUCJHA.3496@TK2MSFTNGP03.phx.gbl...
> Good afternoon Group,
>
> Would somebody please tell me the VBA to :
>
> Copy the worksheet to a new book -by creating it-
> then save it as the cell "B1"
> on "C:\Files"
>
> All assitance on this subject will greatly help me with my daily labors,
>
> Thanks in advance and greetings
>
> Leo Rod
> MIA-FL USA
>

THANKS!!!!


"Don Guillett" <dguillett1@austin.rr.com> wrote in message
news:ep6u4wUCJHA.2056@TK2MSFTNGP05.phx.gbl...
>I just recorded this. See cleaned up below
>
> Sub Macro11()
> '
> ' Macro11 Macro
> ' Macro recorded 8/28/2008 by Donald B. Guillett
> '
>
> '
> Sheets("Sheet2").Select
> Sheets("Sheet2").Copy
> ActiveWorkbook.SaveAs Filename:="C:\files\mynewBook.xls", FileFormat:=
> _
> xlNormal, Password:="", WriteResPassword:="",
> ReadOnlyRecommended:=False _
> , CreateBackup:=False
> End Sub
>
> sub copyshttonewwbandname()
> activesheet.Copy
> ActiveWorkbook.SaveAs Filename:="C:\files\" & range("b1") & ".xls"
> end sub
>
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett1@austin.rr.com
> "Leo Rod" <no spam> wrote in message
> news:ew34vdUCJHA.3496@TK2MSFTNGP03.phx.gbl...
>> Good afternoon Group,
>>
>> Would somebody please tell me the VBA to :
>>
>> Copy the worksheet to a new book -by creating it-
>> then save it as the cell "B1"
>> on "C:\Files"
>>
>> All assitance on this subject will greatly help me with my daily labors,
>>
>> Thanks in advance and greetings
>>
>> Leo Rod
>> MIA-FL USA
>>
>