Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula from closed workbook?
Please advise me is it possible to read/extract a formula from a
closed workbook eg. =IF(ISNUMBER(N26),MAX(N26*$N$2,M26),$O$1) from say cell(26, 15) of a closed workbook, I've tried so far using variations of ExecuteExcel4Macro() and an ADO routine but have only returned values. I have a number of similar workbooks where the contents of that cell can have 1 of 4 different formulas that I need to determine. Thanks in advance Oswald |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula from closed workbook?
I don't have a way.
But I'd just turn off screenupdating, open the other workbook, grab what I need, and close that other workbook. It seems much easier to me. Oswald wrote: Please advise me is it possible to read/extract a formula from a closed workbook eg. =IF(ISNUMBER(N26),MAX(N26*$N$2,M26),$O$1) from say cell(26, 15) of a closed workbook, I've tried so far using variations of ExecuteExcel4Macro() and an ADO routine but have only returned values. I have a number of similar workbooks where the contents of that cell can have 1 of 4 different formulas that I need to determine. Thanks in advance Oswald -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula from closed workbook?
SUMPRODUCT might be what you are looking for.
Depending on how many calculations you have to do it can be a bit slow. Cheers Simon "Oswald" wrote: Please advise me is it possible to read/extract a formula from a closed workbook eg. =IF(ISNUMBER(N26),MAX(N26*$N$2,M26),$O$1) from say cell(26, 15) of a closed workbook, I've tried so far using variations of ExecuteExcel4Macro() and an ADO routine but have only returned values. I have a number of similar workbooks where the contents of that cell can have 1 of 4 different formulas that I need to determine. Thanks in advance Oswald . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook named range not seen by ADO when workbook closed | Excel Programming | |||
FORMULA RETURNS #VALUE WHEN PRESCEDENT WORKBOOK CLOSED | Excel Discussion (Misc queries) | |||
FORMULA RETURNS #VALUE WHEN PRESCEDENT WORKBOOK CLOSED | Excel Programming | |||
Closing Hidden Workbook when Active Workbook is Closed | Excel Programming | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |