yesterdays julian date as filename to link to previous days workbo
 

I am automating some functions of a power plant. Each day we have a new
workbook. They are named in sequence using the julian date. I need to durive
yesterdays file name. I can get the julian dat but to put it in a path and
file name in the formula line is a problem. I know the path. I want to use
the contents of the cell where I have the Julian date. I can't seem to put it
in where it reconizes it. not between []. Can anyone help??