ActiveX: Find method for Excel

[ej]

Does anyone know if the "Find" method for Excel._Worksheet works
properly. I can get the application to replace cells correctly by using
the "Replace" method; but when I try to do a simple "Find", I get back
the message "Exception occured in Microsoft Excel, Find method of Range
class failed. Help Path is XLMAIN8.HLP and context 0 in ".

I've noticed that some of this method's inputs require wiring even
though they are supposed to be optional inputs (according to MSDN). The
most likely possibility is that there is something wrong with my inputs
which are:

hello ---string---> What
A1 ---string---> After
-4163 ---int32----> LookIn
1 ---int32----> LookAt
1 ---int32---
-> SearchOrder
1 ---int32----> SearchDirection

I would appreciate any help.

ej


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

[TWGomez]

Mine works...Give this a try. You can/should change the file path and what you are looking for in the code...this is primitive and incomplete example, just for your benefit. Make real sure you close the activeX connections, or Excel won't work until you close out LabView.