Formula from closed workbook?

O

Oswald

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
 
D

Dave Peterson

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.
 
S

Simon

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
 

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

Access data in a closed workbook with ExecuteExcel4Macro 5
importing data from closed Excel workbook 2
How to tell if sheet exists in closed workbook 4
Error retrieving data from closed workbook 5
Get data from closed workbook for use in a variable (no copying) 3
Copy data from Closed Workbook 3
Code that retrieves values from a closed workbook 1
Determining last row/column using ADO with closed workbook 17

Top