Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Path - Macro | Excel Worksheet Functions | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
Macro help: File path in Excel 2000 | Excel Discussion (Misc queries) | |||
Macro - Feeding path and file name to PDF maker | Excel Discussion (Misc queries) | |||
Import text file without specifying a path macro won't work | Excel Programming |