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

 

[inquirer]

Many thanks

Chris

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