+ Reply to Thread
Results 1 to 6 of 6

Show full path title in title bar?

  1. #1
    Nor
    Guest

    Show full path title in title bar?

    How do you show the complete path for a file in Excell" in the Title Bar?
    e.g. C:\House\budget.xls instead of just budget.xls

  2. #2
    RagDyer
    Guest

    Re: Show full path title in title bar?

    AFAIK, it can't be done, but you can add an "Address" box to either the menu
    bar or a tool bar, which, even though it's intended to facilitate web
    travel, will show the full path to the *saved* WB.

    Right click on the tool bar and choose"Customize".
    <Commands> tab,
    Scroll to and click on "Web" in the left window,
    And the "Address" box is at the top of the right window.

    Drag it to the menu or tool bar, where you can enlarge it to fill whatever
    space you have to spare.

    If you have "long" paths to display, you could simply insert the entire
    "Web" toolbar,
    <View> <ToolBars> <Web>
    which contains this address box, and remove the Web tool icons, leaving this
    address box on a toolbar all it's own.
    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================


    "Nor" <Nor@discussions.microsoft.com> wrote in message
    news:57B6CBD1-E22E-46B1-817E-A5BA5B4B7571@microsoft.com...
    > How do you show the complete path for a file in Excell" in the Title Bar?
    > e.g. C:\House\budget.xls instead of just budget.xls



  3. #3
    Dave Peterson
    Guest

    Re: Show full path title in title bar?

    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

    Nor wrote:
    >
    > How do you show the complete path for a file in Excell" in the Title Bar?
    > e.g. C:\House\budget.xls instead of just budget.xls


    --

    Dave Peterson

  4. #4
    CLR
    Guest

    Re: Show full path title in title bar?

    Hi Dave...........
    I'm not the OP here, but in searching for this code I ran across this old
    post of yours.........your code works SuperFine in my
    application.............thanks for the post!

    Vaya con Dios,
    Chuck, CABGx3



    "Dave Peterson" wrote:

    > 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
    >
    > Nor wrote:
    > >
    > > How do you show the complete path for a file in Excell" in the Title Bar?
    > > e.g. C:\House\budget.xls instead of just budget.xls

    >
    > --
    >
    > Dave Peterson
    >


  5. #5
    Dave Peterson
    Guest

    Re: Show full path title in title bar?

    Google is very nice <vbg>.

    CLR wrote:
    >
    > Hi Dave...........
    > I'm not the OP here, but in searching for this code I ran across this old
    > post of yours.........your code works SuperFine in my
    > application.............thanks for the post!
    >
    > Vaya con Dios,
    > Chuck, CABGx3
    >
    > "Dave Peterson" wrote:
    >
    > > 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
    > >
    > > Nor wrote:
    > > >
    > > > How do you show the complete path for a file in Excell" in the Title Bar?
    > > > e.g. C:\House\budget.xls instead of just budget.xls

    > >
    > > --
    > >
    > > Dave Peterson
    > >


    --

    Dave Peterson

  6. #6
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Show full path title in title bar?

    Did a Google search on this subject and look what I found.

    This is excellent!

    Dave Peterson is sorely missed in the Excel online community!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1