What is the macro "code/function" for a file path and name of an excel file.
I've done this before and recorded a macro that when I push a button a macro
will run to update this information in the footer area of my worksheet.