| 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 |
| 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 | |||
Threaded Mode
