File Path Macro
 

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.

File Path Macro
 

Hi Jen

Look on John's site
http://www.j-walk.com/ss/excel/tips/tip22.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"JenO" wrote in message ...
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.

File Path Macro
 

ActiveWorkbook.FullName


"JenO" wrote in message
...
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.