Use a formula to get the string you use in your formula in a cell... say A1
then use this in B1
=INDIRECT(A1)

Once you get that working then you can replace A1 in the above with the
formula (without the = ofcourse)...

Your string formula should look something like
="'[C:/Testing/Erros - " & text(today(),"mmddyy") & "]Sheetname!'A1:A100"

"Paul Peterson - Velox Consulting, LLC" wrote:

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