View Single Post
Old 07-31-2022, 08:11 AM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2010
Posts: 508
Jamal NUMAN is on a distinguished road

I google it and found the solution below. However, the code needs to be run each time the excel file is open in order to get the path displayed on the title bar

Sub showCaption()
ActiveWindow.Caption = ActiveWorkbook.FullName
End Sub

Attached Images
File Type: jpg Clip_987.jpg (95.8 KB, 6 views)
File Type: jpg Clip_988.jpg (106.6 KB, 6 views)
File Type: jpg Clip_989.jpg (102.8 KB, 6 views)
Reply With Quote