View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default refresh application.caption

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