Complete path info on Excel window

A

Andy

Hi,

Is there an add-in that shows the complete path info of the active workbook
at the top of the Excel window. I thought I had seen it before but I can't
find it through google.

Thanks
Andy
 
R

Ragdyer

Couple of ways to get this.

If you've got the screen room to spare, you can simply add the "Web"
toolbar:
<View> <Toolbars>
And click on "Web".

This gives you, among other tools, the "Address" window, which will display
the full path of all *saved* WBs.

On the other hand, if your strapped for space like me, I added the "Address"
window to my *menu* bar, which always has room to spare.
The size of the window is adjustable, so you can try to display the entire
path at a glance.
This helps a great deal when you have 3 different servers storing varying
types of XL files.

To get the individual window, right click in the toolbar and choose
<Customize>,
Under the "Commands": tab, scroll down in the left window and click on
"Web",
Then, click on and drag the "Address" box to either your toolbar or your
menu bar.

NOW ... while the "Customize" window is *still* open, click on the "Address"
box to select it, then hover the cursor over the right margin until it
becomes a double sided arrow, then click and drag to adjust the size as you
wish.
 
D

Dave Peterson

One more...

You could use an application event that monitors when you change windows.

If you want to try:

You could use this in a new workbook (or add to your personal.xls file).

This goes under the ThisWorkbook module.

Option Explicit
Public WithEvents xlApp As Excel.Application
Private Sub Workbook_Open()
Set xlApp = Application
End Sub
Private Sub Workbook_Close()
Set xlApp = Nothing
End Sub
Private Sub xlApp_WindowActivate(ByVal Wb As Workbook, ByVal Wn As Window)
Wn.Caption = Wb.FullName
End Sub

If you save that workbook in your XLStart folder, then each time excel opens,
this workbook will open.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top