VB.net and Excel Formula errors- Cell prcedent errors

[karyjones]

Hi all,

Iam kartik. Iam trying to develop a application in vb.net which finds the formula errors in a excel workbook, by tracing the prcedents of a given cell..to find the initial cell which actually causing the errors.

Iam able to track the precedents in a give activesheet. but iam not able to trace precedents if they span across other sheets in the same workbook. Also iam not able to track the the hirerarchyof the precedents till the actual error causing cell.

Iam in avery tight time crunch...Please help me...any codes and suggestionsregarding wud be very helpful and grateful


Cheers,
Kartik

[Gizmo001]

Since the error you seek is during runtime, assuming that you are not running any macros in Excel, and all formulas are in vb.net, why can't you catch exceptions at the execution of each formula? E.g.,

Try
... forumyla
catch ex as exception
message.show(ex.message)
end try

Obviously, this won't work if you are using Excel macros built within. But in that case, you can go to the macro-code and do exactly the same.