ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing the name of the workbook when sending it in email (https://www.excelbanter.com/excel-programming/393757-changing-name-workbook-when-sending-email.html)

David A.

Changing the name of the workbook when sending it in email
 
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

Changing the name of the workbook when sending it in email
 
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)


"David A." 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?



David A.

Changing the name of the workbook when sending it in email
 
That's what I thought....

Thanx.

"Chip Pearson" wrote:

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)


"David A." 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?



Jim Cone

Changing the name of the workbook when sending it in email
 

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."
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?


All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com