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
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