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