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

i think i'll just add a column and do the subtraction in the dates workbook, and
then reference that cell. seems much easier.


--


Gary


"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

On Oct 9, 2:28 pm, "Gary Keramidas" <GKeramidasATmsn.com wrote:
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?

Yes - just link the workbook you are working in to the 'closed' one.
as long as you indicate that it is ok to update when you open the WB,
you'll be in business

HTH

AR

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

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