Find location of cell that contains specific text
Hello guys. I've been reading this forum for over a year now and learned tons of stuff from you all. I could not find one specific problem solution so decided to join and ask
What I'm trying to do is find a cell location in excel sheet that contains certain text.
What i have:
Func LoadGBMP()
Local $FileList = _FileListToArray ("Master")
Local $sFileName = @ScriptDir & "\Master\" & $FileList[1]
Local $oExcelDoc = ObjGet($sFileName)
Local $oDocument =
@Laurynelis
Try this example with your test.xlsx file, this code works for me.
#include <MsgBoxConstants.au3>
#include <FileConstants.au3>
#include <Array.au3>
#include <Excel.au3>
Local $sValueToFind = "lol"
Local $sFileOpenDialog = FileOpenDialog("Please select the Excel file", "", "Excel (*.xlsx;*.xlsm;*.xlsb;*.xltx;*.xltm;*.xls;*.xlt;*.xml)", BitOR($FD_FILEMUSTEXIST, $FD_PATHMUSTEXIST))
If @error Then MsgBox($MB_