i wasn't, but i see it now. i added a formula in the closed workbook to do the
math and just used a linking formula to that cell.

thanks
--


Gary


"Tom Ogilvy" wrote in message
...
Yes it is possible.

I assume you are familiar with John Walkenbach's example at
http://j-walk.com/ss/excel/tips/tip82.htm

however, in my experience, it is faster to put a linking formula in a cell,
then replace the formula with the value returned or pick up that value and
clear the cell.

--
Regards,
Tom Ogilvy



"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i have starting dates in a workbook called dates in range B1:B12 (the closed
workbook)
i am trying to subtract one from the another to come up with the number of
days.
i can get it to work if dates is open.

tried this, doesn't work but don't want to spin my wheels if it's not
possible. sheet numbers are 1 to 12.

pDays = Application.Evaluate("='" & fPath & "[dates.xls]sheet1'!$b$" &
sht.Index + 1) - _
Application.Evaluate("='" & fPath & "[dates.xls]sheet1'!$b$" &
sht.Index) - 1


is it possible?

--


Gary