| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing a function script
I need to run a macro that searches a range (column) that contains references
to another spread sheet in the function line e.g., ='I:\REPORTS\Fairfield\[c_090204.xls]Route1'!$G14 The 090204 is yesterday's date. I need to replace 090204 with 090304 (being today's date) in the reference in all cells within the search range. Can this be done automatically without prompting the user to enter the values? I have not been able to figure it out. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DATE SCRIPT / add function col A, | Excel Discussion (Misc queries) | |||
| Help needed (Automatic script function) | Excel Discussion (Misc queries) | |||
| Excel 2000/XP script to Excel97 script | Excel Programming | |||
| Script/function to extract duplicate entries between two columns? | Excel Programming | |||
| Trying to create VBA script to run Report Manager function. | Excel Programming | |||
Threaded Mode
