Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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" wrote in message ... 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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
full path of excel file | Excel Discussion (Misc queries) | |||
Drive and full path in name at top of screen | Excel Discussion (Misc queries) | |||
Remove Hyperlinks...show the Path | Excel Discussion (Misc queries) | |||
Range name & Full Path in Footer | Excel Discussion (Misc queries) | |||
How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) |