| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable file names
I have a formula that references another excel workbook. The name of this
workbook will be different depending on the date. Yesterday, I summed numbers from C:/Testing/Errors - 021609; today I will sum numbers from a different workbook named C:/Testing/Erros - 021709. In my worksheet, I have to manually change the reference to reflect the current date. Is there a way to make that name variable based on today's date? Any help would be appreciated. Paul Peterson Velox Consulting, LLC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference other worksheets via variable names | Excel Worksheet Functions | |||
| Variable Worksheet Names | Excel Worksheet Functions | |||
| creating a variable for file names | Excel Discussion (Misc queries) | |||
| variable file names | Excel Discussion (Misc queries) | |||
| Variable Names in Formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
