Want to run macro that updates part of a formula reference

[jm2241]

Is it possible to write a macro that updates the file referenced within a formula to a file precreated and named after today on a daily basis; such as the reference to file "A_20070223" will become file"A_20070224" (or T will become T+1) within the formula by running a macro? The goal is to be able to update the one spreadsheet daily with new data saved in various folders with the macro.

The formula looks similar to this:

=SUM([A_20070223.xls]Sheet1!$A$1:$A$16)+SUM([A_20070223.xls]Sheet2!$A$1:$A$16)+SUM([B_20070223.xls]Sheet1!$A$1:$A$16)+SUM([B_20070223.xls]Sheet2!$A$1:$A$16)

Thanks in advance for any help!

[mudraker]

Use this macro for your starting point

Please Login or Register  to view this content.