Follow up: Find method for Excel

[ej]

For those of you who are interested, the problem that I had with the
Excel "Find Method --

"Error 1004
Exception occured in Microsoft Excel, Find method of Range
class failed. Help Path is XLMAIN8.HLP and context 0 in "

-- is a common issue for the ActiveX "Find Method" and something that
Microsoft needs to fix. Their developer pages said that it is a bug
that occurs when the search item cannot be found and can be worked
around with good error handling. However, I get the same error when the
word that I'm searching for is present. I've got other solutions to my
problem, but they are so sloooow.

ej


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

[SmplLbV123]

I think this is what I need for my application. Can you please post up your VI? What I need is to search for a string and return me the row and column number if it's found. Thanks!

[THailey3]

Hi Pas123!

First off, it looks like EJ's post was made in 1999... so I'm thinking that you're probably not going to get a response from him 🙂

Secondly, you might find this link useful. It describes using the Excel Find method and also gives an example with VBA. Porting this functionality to LabVIEW is only a matter of figuring out how the ActiveX class is built.

http://www.dicks-blog.com/archives/2004/03/29/the-find-method/

Hope this helps, and good luck!

Travis H.
National Instruments