How to see full path name of open workbook?
in [General]
|
From: Joe User on 18 Mar 2010 00:22 Is there a simple way to see the full path name (folder and file name) of an open workbook?
From: Ed Ferrero on 18 Mar 2010 01:10 Hi Joe, =CELL("filename",A1) Ed Ferrero www.edferrero.com
From: Gord Dibben on 18 Mar 2010 11:46 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?
From: Joe User on 18 Mar 2010 13:53 "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 news:cii4q5tu9he6umkgm6mem0kcuivgku2kvj(a)4ax.com... > 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? >
From: Gord Dibben on 18 Mar 2010 17:56
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 >news:cii4q5tu9he6umkgm6mem0kcuivgku2kvj(a)4ax.com... >> 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? >> |