Windows Forum

Ask something
Discussion Locked

display path along with filename

0 helpful
1 reply

by kzagzebski

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to include the path with the filename in the application (top) bar in office applications, as well as in custom headers and footers?

1 reply

by dklippert

Here are a copuple of macros:

Word:

Sub AutoOpen()
ActiveWindow.Caption = ActiveDocument.FullName
End Sub

Sub FileSave()
ActiveDocument.Save

With ActiveDocument
.ActiveWindow.Caption = ActiveDocument.FullName
End With

Excel:

End Sub
Private Sub Workbook_Open()
Application.Caption = ActiveWorkbook.Path
End Sub

This discussion is closed to new replies.