On 2017-05-01 10:20, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
On 2017-04-26 16:08, Richard Kaye wrote:
Looks to me like your current solution is storing a formula in a
remote cell which you said you wanted to avoid.
Good point. I had (temporarily) relented on that.
Just tried it and your code worked perfectly. THANKS!!!!!!
* Now open its child DETAILS table and confirm
oExcel.Workbooks.Open(Detail,.F.,.T.) && false to UpdateLinks; true
to open ReadOnly
WITH oExcel.ActiveSheet as EXCEL.Worksheet
DetailClaims =
oExcel.WorksheetFunction.CountA(.Range("Details!R:R")) - 1
DetailCaid =
oExcel.WorksheetFunction.Sum(.Range("Details!R:R"))
DetailCharges =
oExcel.WorksheetFunction.Sum(.Range("Details!Q:Q"))
DetailCare =
oExcel.WorksheetFunction.Sum(.Range("Details!S:S"))
ENDWITH && oExcel.ActiveSheet as EXCEL.Worksheet
oExcel.ActiveWorkbook.Close()
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/a9e5dc01e1a345e1b74e7f846b90b...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
