View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ntoze
 
Posts: n/a
Default Full path in title bar

There seems to be a problem with putting the path in the title bar
using the workbook open event. The problem is, if you have code like
this:

Set a_workbook = Application.Workbooks.Open("abc.xls", 0, True)

And abc.xls has a VBA reference to another workbook. Then a_workbook
will (or at least it will with my workbook) be set to the referenced
workbook, not abc.xls. Which is not the behaviour if the workbook open
event is not used.