View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?