How can I rename a Workbook?

[Mac Lingo]

Is there a procedure to change the name of a workbook once it's in Excel?
Thanks,
Mac Lingo

[Paul B]

Mac, you can change the name in windows explorer or just do a file, save as
when you have the workbook open and save it as another name

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mac Lingo" <[email protected]> wrote in message
news:[email protected]...
> Is there a procedure to change the name of a workbook once it's in Excel?
> Thanks,
> Mac Lingo
>
>

[Chip Pearson]

Mac,

The name of a workbook is its file name, so you can't change the
name without changing the file name. In VBA you can do this with

Sub AAA()
ActiveWorkbook.SaveAs filename:="theNewName.xls"
End Sub

or you can close the file and change the name in Windows
Explorer.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Mac Lingo" <[email protected]> wrote in message
news:[email protected]...
> Is there a procedure to change the name of a workbook once it's
> in Excel?
> Thanks,
> Mac Lingo
>