Formula from closed workbook?

  • Thread starter Thread starter Oswald
  • Start date Start date
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
 
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.
 
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
Error retrieving data from closed workbook 5
PUT data in closed workbook 5
Copying cells and formula from closed workbook to all sheets in open workbook 0
importing data from closed Excel workbook 2
VB help with ExecuteExcel4Macro 7
Sheet names from closed workbooks 1
Copy Multiple Areas from One Workbook to Another 4

Back
Top