Importing File Name Into Header

Hello Everyone!

Is it possible to import a file name into header? The catch is that the file name that I need is not the file name of the workbook I am in. I have seen ways it can be done but they bring the entire file path instead of just the file name. I would like to be able to use this method to point to file to grab name from.

Application.GetOpenFilename("Excel Files (*.xls), *.xls")

Thank You.