Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to see full path name of open workbook?
Is there a simple way to see the full path name (folder and file name) of an
open workbook? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to see full path name of open workbook?
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to see full path name of open workbook?
Where do you want to see this?
If you display the Web Toolbar you will see path and name if the bar. On the Title Bar? Add this code to Thisworkbook module. Private Sub Workbook_Open() ActiveWindow.Caption = ActiveWorkbook.FullName End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Gord Dibben MS Excel MVP On Wed, 17 Mar 2010 21:22:04 -0700, "Joe User" <joeu2004 wrote: Is there a simple way to see the full path name (folder and file name) of an open workbook? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to see full path name of open workbook?
"Gord Dibben" <gorddibbATshawDOTca wrote:
If you display the Web Toolbar you will see path and name Thanks. That will do nicely. On the Title Bar? Yeah, that's my preference. But it's not worth creating a Workbook_Open macro just for this unless I want to apply it to all Excel files that I open. Not sure if I do. However.... Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Why bother? Just good practice to restore the default, for example if I only want to apply this to one workbook, but not others open subsequently in the same Excel instance? Just to show me how, in case I wanted to? (Good idea.) Or is this an Excel requirement?(!) ----- original message ----- "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Where do you want to see this? If you display the Web Toolbar you will see path and name if the bar. On the Title Bar? Add this code to Thisworkbook module. Private Sub Workbook_Open() ActiveWindow.Caption = ActiveWorkbook.FullName End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Gord Dibben MS Excel MVP On Wed, 17 Mar 2010 21:22:04 -0700, "Joe User" <joeu2004 wrote: Is there a simple way to see the full path name (folder and file name) of an open workbook? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to see full path name of open workbook?
Not necessary to have the BeforeClose event.
Other workbooks opened subsequently will not have the full path. Gord On Thu, 18 Mar 2010 10:53:27 -0700, "Joe User" <joeu2004 wrote: "Gord Dibben" <gorddibbATshawDOTca wrote: If you display the Web Toolbar you will see path and name Thanks. That will do nicely. On the Title Bar? Yeah, that's my preference. But it's not worth creating a Workbook_Open macro just for this unless I want to apply it to all Excel files that I open. Not sure if I do. However.... Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Why bother? Just good practice to restore the default, for example if I only want to apply this to one workbook, but not others open subsequently in the same Excel instance? Just to show me how, in case I wanted to? (Good idea.) Or is this an Excel requirement?(!) ----- original message ----- "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Where do you want to see this? If you display the Web Toolbar you will see path and name if the bar. On the Title Bar? Add this code to Thisworkbook module. Private Sub Workbook_Open() ActiveWindow.Caption = ActiveWorkbook.FullName End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Gord Dibben MS Excel MVP On Wed, 17 Mar 2010 21:22:04 -0700, "Joe User" <joeu2004 wrote: Is there a simple way to see the full path name (folder and file name) of an open workbook? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to see full path name of open workbook?
Put the following code in the ThisWorkbook module of your Personal.xls
workbook (or any other workbook that is normally always open). Private WithEvents App As Excel.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 Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Wed, 17 Mar 2010 21:22:04 -0700, "Joe User" <joeu2004 wrote: Is there a simple way to see the full path name (folder and file name) of an open workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find file-path of open workbook? | Excel Discussion (Misc queries) | |||
Macro to open Workbook in default path. | Excel Discussion (Misc queries) | |||
How to open Excel workbook in full size window | Excel Discussion (Misc queries) | |||
How to Display Full Path for File Diplayed at Top Of Workbook | Excel Discussion (Misc queries) | |||
Workbooks.Open with out full path help needed. | Excel Discussion (Misc queries) |