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

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)


"Peter" wrote in message
...
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

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/groups?thre...B671%40msn.com
and if that doesn't work, a link to the same thread:
http://groups-beta.google.com/group/...0663f92e54955c
(one line in your browser)


Peter wrote:

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

--

Dave Peterson