Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show full path of files being saved
At times while working on my notebook and using the network, it is helpful
when saving a file to show the complete path of the file I am saving. Is it possible to tweak the setup in Excel to show the whole path rather than just the filename? Now when I save, or save as, I get the file name only. Thanks for any help and direction here. Jerry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show full path of files being saved
Is this any help? You can use this formula
=CELL("filename") ....to show the full path and filename. This works when you have saved the file first. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show full path of files being saved
Private WithEvents App As Application
Private Sub App_WindowActivate(ByVal Wb As Workbook, ByVal Wn As Window) Wn.Caption = Wb.FullName End Sub Private Sub Workbook_Open() Set App = Application End Sub This is workbook event code. To input this code, right click on the Excel icon on the worksheet (or next to the File menu if you maximise your workbooks), select View Code from the menu, and paste the code -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "JERRY" <jerry@home wrote in message ... At times while working on my notebook and using the network, it is helpful when saving a file to show the complete path of the file I am saving. Is it possible to tweak the setup in Excel to show the whole path rather than just the filename? Now when I save, or save as, I get the file name only. Thanks for any help and direction here. Jerry |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show full path of files being saved
Relatively shallow user here. So while your suggestion is appreciated, it is
not fully understood. Are you speaking of copying and pasting just the following three lines in the suggested location? ------------------------------------------ Private Sub Workbook_Open() Set App = Application End Sub --------------------------------------------- Jerry "Bob Phillips" wrote in message ... Private WithEvents App As Application Private Sub App_WindowActivate(ByVal Wb As Workbook, ByVal Wn As Window) Wn.Caption = Wb.FullName End Sub Private Sub Workbook_Open() Set App = Application End Sub This is workbook event code. To input this code, right click on the Excel icon on the worksheet (or next to the File menu if you maximise your workbooks), select View Code from the menu, and paste the code -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "JERRY" <jerry@home wrote in message ... At times while working on my notebook and using the network, it is helpful when saving a file to show the complete path of the file I am saving. Is it possible to tweak the setup in Excel to show the whole path rather than just the filename? Now when I save, or save as, I get the file name only. Thanks for any help and direction here. Jerry |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show full path of files being saved
Bob's suggestion changed the application's title bar to display the whole path,
but you need both of his procedures in your ThisWorkbook module. DaveO's suggestion was a worksheet formula. Although, I would have used: =cell("Filename",a1) (including a reference to a cell in the same workbook Debra Dalgleish has another variation: http://contextures.com/xlfaqFun.html#SheetName And if you only need it occasionally, you can look under: file|properties|general tab JERRY wrote: Relatively shallow user here. So while your suggestion is appreciated, it is not fully understood. Are you speaking of copying and pasting just the following three lines in the suggested location? ------------------------------------------ Private Sub Workbook_Open() Set App = Application End Sub --------------------------------------------- Jerry "Bob Phillips" wrote in message ... Private WithEvents App As Application Private Sub App_WindowActivate(ByVal Wb As Workbook, ByVal Wn As Window) Wn.Caption = Wb.FullName End Sub Private Sub Workbook_Open() Set App = Application End Sub This is workbook event code. To input this code, right click on the Excel icon on the worksheet (or next to the File menu if you maximise your workbooks), select View Code from the menu, and paste the code -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "JERRY" <jerry@home wrote in message ... At times while working on my notebook and using the network, it is helpful when saving a file to show the complete path of the file I am saving. Is it possible to tweak the setup in Excel to show the whole path rather than just the filename? Now when I save, or save as, I get the file name only. Thanks for any help and direction here. Jerry -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to change the path of the linked files - thousands of them. | Excel Discussion (Misc queries) | |||
how do I show last date file saved? | Excel Worksheet Functions | |||
Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) | |||
How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) | |||
How do I show the last saved date in an Excel worksheet? | Excel Worksheet Functions |