detecting #REF! from interop

[db042188]

Hi. I hope I'm allowed to post the same question in 2 forums. I'm getting no responses in the other.

We have a c# program that visits hundreds of thousands of cells in about 60 spreadsheets across approx 1600 tabs to discover formulas. The formulas assist in determining new files that need to be visited. Circular references are handled.

We believe that more than a few of the cells have invalid references. But we dont know how to detect that "state" going thru interop from c#.

One promising item I saw today was the iserror(formula) "macro". Can I invoke this macro from c# thru interop to determine at the very least that something is wrong with a particular formula I've encountered? If so, how?

Is there a more direct way to detect #REF! specifically thru interop from c#?

 

[db042188]

I'm not a c# guy but the info at
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.worksheetfunction.iserror.aspx seems promising. I didnt see this article yesterday when I first started searching for info on this subject.