Changing the name of the workbook when sending it in email

's Computer Specifications

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?

's Computer Specifications

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." <(E-Mail Removed)> wrote in message
news:928A3ADC-1E8C-40C6-8A85-(E-Mail Removed)...
>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?

's Computer Specifications

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." <(E-Mail Removed)> wrote in message
> news:928A3ADC-1E8C-40C6-8A85-(E-Mail Removed)...
> >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?
>

's Computer Specifications

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." <(E-Mail Removed)>
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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot reactivate workbook after sending email in VBA	Phrank	Microsoft Excel Programming	0	6th Feb 2007 01:55 AM
Changing email accounts prior to sending an email	=?Utf-8?B?UGl0Y2gx?=	Microsoft Outlook Discussion	4	1st Nov 2004 01:22 PM
Changing default email displayed in Outlook when sending email.	=?Utf-8?B?RGVqYWRvbw==?=	Microsoft Outlook Discussion	2	23rd Sep 2004 05:47 AM
Sending Workbook By Email	Ben Allen	Microsoft Excel Programming	8	14th Mar 2004 01:50 PM
Sending email WITHOUT attaching a workbook?	Kobayashi	Microsoft Excel Programming	2	25th Sep 2003 02:20 PM