View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Full path possible to be seen?

One more...

You could use an application event that monitors when you change windows.

If you want to try:

You could use this in a new workbook (or add to your personal.xls file).

This goes under the ThisWorkbook module.

Option Explicit
Public WithEvents xlApp As Excel.Application
Private Sub Workbook_Open()
Set xlApp = Application
End Sub
Private Sub Workbook_Close()
Set xlApp = Nothing
End Sub
Private Sub xlApp_WindowActivate(ByVal Wb As Workbook, ByVal Wn As Window)
Wn.Caption = Wb.FullName
End Sub

If you save that workbook in your XLStart folder, then each time excel opens,
this workbook will open.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Octavio wrote:

Where to set Excell so the Excell window and file that I am working with
shows the full path (full path.xls) of where the folders are in the upper
left hand side line of the window?


--

Dave Peterson