Using the 'Find' method of an Excel Worksheet ActiveX invode node

[karin]

I am trying to search an excel worksheet for a specific string using the FIND method of an ActiveX invoke node on an excel worksheet.
What are the datatypes and formats of the different parameters to this method and what do they accomplish? specifically the 'After' and 'LookAt' parameters?

[Gorka Larrea]

What: The info you are looking for, it can be a character string or any data type you are looking for in excel.

After: The cell after which you want to find, it corresponds to the active cell when find is made by user interface.

LookIn: Where to look, in formulas (-4123), values (-4163) or notes (-4144)

LookAt: Look at whole or part (1,2)

SearchOrder: By rows (1) or by columns (2)

SearchDirection: Next or previous (1,2)

MatchCase: True for upper and lowercase distinction

MatchByte: only for assian office

You can find this info in the VBA help, and you can use object examiner (sorry for the traduction) in VBA to know values.
Hope this helps