Search Function in Excel

General
1

Hi,
Can anyone guide me to how to search the keyword in excel file using xojo.

2

Have you looked up how to work with Excel in general: ? Create a macro in Excel and perform the actions you want. Open the macro in VBA and there is the code you need to port to Xojo.

The code to search for a specific keyword:

Cells.Find(What:="thiskeyword", After:=ActiveCell, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False).Activate

3

@Pathma Mu. follow the code that Alexander has mentioned, since the Find keyword is what is needed for Searching in Excel. Chapter 8 of the book Program Excel 2016 with Xojo in Windows has various examples of Xojo code using the Find and Replace methods for Excel.