possible to subtract 2 dates from a closed workbook?

  • Thread starter Thread starter Gary Keramidas
  • Start date Start date
G

Gary Keramidas

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?
 
i think i'll just add a column and do the subtraction in the dates workbook, and
then reference that cell. seems much easier.
 
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?
Click to expand...

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.
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

importing data from closed workbook 1
pulling information from a closed workbook 1
help with copying column between 2 workbooks through vba 2
Cell values to an array, then array transpose to another workbook 8
Sound repeats unending until closing workbook 2
Transpose & reorg data from 2 WS to new WB 2
How to reference a cell from anther workbook without opening it 0
Writing own formula 2 3

Back
Top