PDA

View Full Version : If statement to look for now()-1 in another file



obriensj
06-24-2009, 04:47 AM
Hi,
I need an if statement to look for the present day now()-1 and pick up a cell ref from a file stored in a folder day before.
So for today 24th June I need the if statement to look for
H:\test\History\4400161_Jun_23_09.xls and ref cell D410.
However the next day I need the same thing to happen but this time will look for
H:\test\History\4400161_Jun_24_09.xls
As we move on every day I need the if statement to look at the previous day’s file and pick up cell D410, can this be done?
The file name will always start with H:\test\History\4400161­…just the actual date that increases everyday.

Many Thanks

JONvdHeyden
06-24-2009, 05:02 AM
You seem to need the INDIRECT.EXT worksheet function available through the morefunc addin.

Addin available here: http://xcell05.free.fr/morefunc/english/

obriensj
06-24-2009, 06:18 AM
Hi, the link does not open???

JONvdHeyden
06-24-2009, 08:04 AM
What does it do when you click on it? It works for me.

obriensj
06-25-2009, 08:19 AM
It says:
We're sorry, the page you have requested cannot be found or is no longer available.

Click here to go to the summary : http://xcell05.free.fr (http://xcell05.free.fr/)

Aussiebear
06-25-2009, 10:37 PM
Try this link: http://www.businesswarelist.com/morefunc-download/