show filename below the ribbon

Hello Chaps
I have been watching a video on vlookup that is on the utube

I see that there is a filename below the ribbon which the demonstrator
clicks on to enter the file path into the vlookup instruction.
I am using excel 2013 and i cannot see how to get that filename
to display on my workbook
Will you please look at the video at the link below and you will
see what i mean.

The filename appears above the sheet between the ribbon and the
top of the sheet. You will see it appear as soon as the presenter
selects "arrange all " "display vertically"

Someone please tell me how to get the filename to appear

https://www.youtube.com/watch?v=6pSYP2plbdI

The macro I am writing is requiring a number of lookups on different
workbooks and to automatically select the "path" will eliminate a lot
of spelling errors on my part

Many thanks

fred from south africa

Hello Glenn
Sorry- that didnt work ,
Are you using excel 2010 or excel2013
I am using 2013
I am wondering if this is something that has been left out of the new version??

Anyway what I am looking for is a way to load or copy the filename and path into
the clipboard so I can paste it into a command
regards

fred

Thanks Glenn - much appreciated

fred

thanks chaps-- while the original question has not been answered i have been given
the solution to my problem by debra at contextures
in order to get the workbook path and address into a vlookup in a different (open)
workbook the writer must do the following
in the cell where the vlookup is to be located - type in =vlookup(
now move to the other workbook and double click in any empty cell
the vlookup statement will have the address added to it after the bracket
(some minor tweaking of the vlookup() may be nessesary to remove incorrect
cell numbers, etc but the correct path will have been entered where it is needed)