workbook extension

[Jase]

Hi All

I have a workbook called xyz, so at the top of the screen
it say "Microsoft Excel = xyz.xls" ie. the name of the
work book is xyz.xls.

Is it possible to make the name of the workbook just "xyz"
so at the top of the screen it will say "Microsoft Excel -
xyz"?

Thanks heaps
Jase

 

[Myrna Larson]

I suppose you can give it any name you like using File/Save As, and put the name in quotes. But
if you do that, you will not be able to open it by clicking the file name from Windows Explorer,
etc, and in the File/Open dialogs you'll have to explicitly type the name or enter *.* in the
name box or select files of all types. Doesn't seem worth the effort to me....

 

[Kevin Stecyk]

Jase,

Not sure if I am hitting the target, but you might want to look at some
threads in Google that have "application caption" as key words.

Here are some archived posts that might assist you.

Regards,
Kevin

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: Derrick Lee Rademaker
Subject: Re: Application.Caption


View this article only
Newsgroups: microsoft.public.excel.programming
Date: 2002-09-15 04:29:05 PST


Use the following code

Application.Caption = "my Program"
Activewindow.Caption = ""

HTH

Derrick

"Dean R Thomas" wrote in message

I'm using Excel'97: I want to rename the ApplicationTitle.
Application.Caption enables us to drop off the "Microsoft Excel" from the
Title and replace it with whatever we wish. Is there a means to drop the
file name from the title?

Application.Caption = "My Program"

produces:

My Program - {file name}

Can we drop {file name}

Dean Thomas

From: Soniya
Subject: Application.Caption


View this article only
Newsgroups: microsoft.public.excel.programming
Date: 2003-03-05 22:49:35 PST


Hi All,

How can I avoid showing file name in the
Application.caption ? Even if I change it at the end File
name is shown?

also How can I change Excel Icon shown on the left of
application.caption to my choice?

TIA
Soniya
Message 6 in thread
From: Shailesh Shah
Subject: Re: Application.Caption


View this article only
Newsgroups: microsoft.public.excel.programming
Date: 2003-03-05 23:35:37 PST


Hi,

How can I avoid showing file name in the
Application.caption ? Even if I change it at the end File
name is shown?

Put below code to your thisworkbook's codmodule.

Private Sub Workbook_WindowActivate(ByVal Wn As Window)
Application.Caption = "Pgm. By Soniya"
ActiveWindow.Caption = ""
End Sub

Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
Application.Caption = ""
End Sub




Regards,
Shah Shailesh

 

[Gord Dibben]

A caveat regarding this code.

Application.Caption = "my Program"
Activewindow.Caption = ""

Will not stick when opening another workbook or when closing Excel.

Should be placed in the ThisWorkbook module as a Workbook_Open() or as an
Auto_Open in a general module.

Gord Dibben XL2002

 

[Kevin Stecyk]

Gord,

Thank you very much!

Regards,
Kevin

A caveat regarding this code.


Will not stick when opening another workbook or when closing Excel.

Should be placed in the ThisWorkbook module as a Workbook_Open() or as an
Auto_Open in a general module.

Gord Dibben XL2002