refresh application.caption

[Peter]

Hello everyone,

(Problem in : Win 2k, Off 2k)

In almost all of my excel files that I use regularly in the office and at
home I have the Workbook_Open, -_Activate and -_Deactivate events programmed
to alternate between showing "Microsoft Excel" (for files that are not yet
saved) and the full path of the file as a the applications caption.

However, if I save an already saved file to a different location, lets say
memory stick designated as F:, the caption is not refreshed to F:\ [rest of
path] - [FileName]

How can I make shure that after such a save-action the application.caption
string is immediately refreshed as is intended?

Greetings,
Peter

 

[Bob Phillips]

Peter,

Problem here, as the only Save event you could trap is BeforeSave, and at
that point the path is still not known. The only thing I could think of is
if you have multiple windows to activate another and then return to the
original, forcing the activate event to fire.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

Another option (instead of having almost identical code in each workbook) is to
use one workbook that's always looking for what window is active.

You can use an application event for this kind of thing:

http://groups.google.com/[email protected]
and if that doesn't work, a link to the same thread:
http://groups-beta.google.com/group/microsoft.public.excel.misc/browse_frm/thread/bb0663f92e54955c
(one line in your browser)

Hello everyone,

(Problem in : Win 2k, Off 2k)

In almost all of my excel files that I use regularly in the office and at
home I have the Workbook_Open, -_Activate and -_Deactivate events programmed
to alternate between showing "Microsoft Excel" (for files that are not yet
saved) and the full path of the file as a the applications caption.

However, if I save an already saved file to a different location, lets say
memory stick designated as F:, the caption is not refreshed to F:\ [rest of
path] - [FileName]

How can I make shure that after such a save-action the application.caption
string is immediately refreshed as is intended?

Greetings,
Peter