changing name of workbook

[inquirer]

In vb code I create a new workbook which is given a name say "book22.xls".

How can I change the name of the workbook to say "reports_today.xls" so that
later I can call up this workbook by this name?

Thanks
Chris

[Norman Jones]

Hi Inquirer,

Set the name directly when the workbook is opened:

Sub Tester()
Dim WB As Workbook

Set WB = Workbooks.Add

WB.SaveAs "reports_today.xls"

End Sub


---
Regards,
Norman



"inquirer" <noreply@noreply.com> wrote in message
news:utY2v0S%23EHA.3988@TK2MSFTNGP11.phx.gbl...
> In vb code I create a new workbook which is given a name say "book22.xls".
>
> How can I change the name of the workbook to say "reports_today.xls" so
> that
> later I can call up this workbook by this name?
>
> Thanks
> Chris
>
>

[inquirer]

Many thanks

Chris
"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:%23vDIx$S%23EHA.2192@TK2MSFTNGP14.phx.gbl...
> Hi Inquirer,
>
> Set the name directly when the workbook is opened:
>
> Sub Tester()
> Dim WB As Workbook
>
> Set WB = Workbooks.Add
>
> WB.SaveAs "reports_today.xls"
>
> End Sub
>
>
> ---
> Regards,
> Norman
>
>
>
> "inquirer" <noreply@noreply.com> wrote in message
> news:utY2v0S%23EHA.3988@TK2MSFTNGP11.phx.gbl...
> > In vb code I create a new workbook which is given a name say
"book22.xls".
> >
> > How can I change the name of the workbook to say "reports_today.xls" so
> > that
> > later I can call up this workbook by this name?
> >
> > Thanks
> > Chris
> >
> >
>
>