Changing the name of the workbook when sending it in email

[Guest]

I have a workbook that I need to change the name of when I send it out. The
working workbook is lets say "david's Team" I need it to go out as "NBO
Team". Can this be done?

 

[Chip Pearson]

David,

The name of a workbook is its file name. You can't change the name of a
workbook unless you do a SaveAs or SaveCopyAs.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Guest]

That's what I thought....

Thanx.

David,

The name of a workbook is its file name. You can't change the name of a
workbook unless you do a SaveAs or SaveCopyAs.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Jim Cone]

If the file is closed, you can change the file name in Windows Explorer.
Right-click the file and select Rename on the popup menu.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"David A." <[email protected]>
wrote in message
I have a workbook that I need to change the name of when I send it out. The
working workbook is lets say "david's Team" I need it to go out as "NBO
Team". Can this be done?