changing name of workbook
 

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

changing name of workbook
 

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" wrote in message
...
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

changing name of workbook
 

Many thanks

Chris
"Norman Jones" wrote in message
...
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" wrote in message
...
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