advanced reference question reworded

[Chad]

Ok I have a cell that references a workbook titled June Sales.xls and one
cell that references July Sales.xls Is there a way to write a macro that
would check all formulas for any month and replaces it with the current
month. So that if I ran the macro today both the cells above would end up
referencing February Sales.xls?

 

[JBeaucaire]

One thing to remember, though, INDIRECT doesn't work with closed workbooks.
They will need to be open.

If you must work with closed workbooks, there is an addin called MOREFUNC
and it includes a replacement function called INDIRECT.EXT() that works on
closed workbooks.

You can download it from here:
http://www.download.com/Morefunc/3000-2077_4-10423159.html

Install it, then click on TOOLS > ADDINS and activate MOREFUNC.

You can read up on using the various functions here:
http://xcell05.free.fr/morefunc/english/#Functions