Complete path info on Excel window
 

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

Complete path info on Excel window
 

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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

Complete path info on Excel window
 

Thanks Ragdyer, this is very helpful and exactly what I want.

"Ragdyer" wrote in message
...
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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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

Complete path info on Excel window
 

You're welcome, and appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Andy" wrote in message
...
Thanks Ragdyer, this is very helpful and exactly what I want.

"Ragdyer" wrote in message
...
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.
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

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

Complete path info on Excel window
 

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


Andy wrote:

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

--

Dave Peterson