If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
How to see full path name of open workbook?
|
#3
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|