| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell formula that captures name of the file's folder
Hi,
How does one capture the folder name in which a file resides? I want to ensure that the folder name (in this case a date) is always indicated in a cell in a spreadsheet. I could always use a pop-up calendar that the user can enact, but I want to force this date cell to always have the correct date (not necessarily the current date), and this date will be the name of the folder (e.g. "F0607_5FEB"). Thanks in advance, -- Kent Lysell Financial Consultant Ottawa, Ontario W: 613.948-9557 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is this possible , screen captures with a macro? | Excel Worksheet Functions | |||
| How do I list a folder of "Excel file's names" to an Excel spdsht | Excel Discussion (Misc queries) | |||
| What formula captures specified rows of data? | Excel Worksheet Functions | |||
| Checking for Changes in File's Cell Layout | Excel Programming | |||
| Formula that captures criteria from 2 different columns "Help ME" | Excel Programming | |||
Threaded Mode
