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

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" wrote in message
ink.net...
Is there a procedure to change the name of a workbook once it's in Excel?
Thanks,
Mac Lingo

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" wrote in message
ink.net...
Is there a procedure to change the name of a workbook once it's
in Excel?
Thanks,
Mac Lingo