How do I search for a value in an Excel sheet using ActixeX

[NIDave]

I am already accessing my excel sheets however I need to be able to search the sheet for a certain value and return the row/cell location. Is there an activeX control that can do this?

[Michael_Munroe]

You will need a reference to the range to search. This can be the entire sheet if you wish. Just wire that to the method node Find. Here you can specify all of the typical search options. Wire your string or number into the What input. For the what to LOOKAT value, use -4163 for Value and -4123 for formulas.

The reference returned is the range of the found value. You can wire it into the property node Row and Column to get the location.

Michael Munroe
www.abcdef.biz

[NIDave]

Thanks for your help, I found the right node but still cannot get that node to work. Ill attach the code I have and perhaps you can comment on it. I get error -2147352565 at the find value node.
Thanks for all your help.
-Dave

[Michael_Munroe]

Oops. My error. Your code was perfect. The options that I provided are for the LOOKIN parameter, not the LookAt parameter. Make that one change and you are good to go.

Michael

[NIDave]

Great, it works perfectly!
Thanks again Michael.