| 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 | |||
Hybrid Mode
