Search for a string in excel file

[baamr]

Hi,

Is it possible with Autoit to search  for a string in an Excel file and give the result of another cell?

Eg. I found my result for a search in cell C4  and want to show the text i have in cell B4.

Thanks for any help.

 

Edited October 2, 2022 by baamr
Missing ?

[water]

Sure.
Use function _Excel_RangeFind and the addresses of the cells containing the search string will be part of the returned array.
Then use the Offset property to calculate the new address.

[baamr]

Hi,

I can not find this method Range.Offset property in Autoit. Is it a part of Autoit?

It looks more like VB visual basic?

[Danp2]

Here's one of @water's old examples from the forum --

 

[water]

AutoIt allows to access properties and methods of Excel using COM. 
Details about COM can be found in the AutoIt help file. 

Edited October 3, 2022 by water

[baamr]

5 hours ago, Danp2 said:

Here's one of @water's old examples from the forum --

 

Thanks, Think i can sort out something from that one.

[baamr]

Hi,

I get error with $oExcel not declared as global var.

I have Include: array.au3 and excel.au3

Were is $oExcel defined?

 

Edited October 4, 2022 by baamr
pic

[water]

$oExcel is the variable to hold the reference to the Excel application object. This is returned by _Excel_Open.
You have to declare the variable yourself.
Please check the examples in the help file.

Edited October 4, 2022 by water

[baamr]

Thanks again,  🙂