Search the Community
Showing results for tags '_excel_rangefind'.
After AutoIt 126.96.36.199 the handling of COM errors has been "fixed". Now nested COM operations crash the script in case of an error even when there is a COM error handler. Edit: All 3 problems have been fixed in AutoIt 188.8.131.52. Here you find a fixed version of function _Excel_RangeFind. I simply removed all nestings and added the missing COM error hander: Another function that needed some modification is _Excel_BookOpen. It crashed when a workbook was opened using _Excel_BookOpen with parameter $bVisible = True, saved and then reopened. The following modification solve
Hi I have an issue with _ExcelRangeFind, i have a it working on another PC but on my pc i just gives me this error "d:\AutoIt3\Include\Excel.au3" (656) : ==> The requested action with this object has failed.: $aResult[$iIndex] = $oMatch.Name.Name $aResult[$iIndex] = $oMatch^ ERROR I have trimmed the script to the absolute minimum. What iy should do, I give it a number, It opens an excel file, and then it reads through coloumn A and then returns an array when it finds the number in Excel. The number is in coloumn A of the Excel sheet. The versions of autoit are the same on both machine
Cheers, Hit a snag automating some excel stuff and I think this parameter could be what I need. Unfortunately cant find any examples/instructions on how to use it. A shove in the right direction would be greatly appreciated. $iLookIn [optional] Specifies where to search. Can be any of the XLFindLookIn enumeration (default = $xlValues) Bill
Hi, anybody know what this is about? I have tried on three different PC's all give me the same error whether my own code or the Help File Examples... All other excel func's work fine. ( haven't tested them all but most) >Running:(184.108.40.206):C:\Users\XXXXX\Desktop\autoit-v3\install\autoit3.exe "C:\Users\XXXXX\Desktop\autoit-v3\install\Examples\Helpfile\_Excel_RangeFind.au3" --> Press Ctrl+Alt+Break to Restart or Ctrl+Break to Stop "C:\Users\XXXXX\Desktop\autoit-v3\install\Include\Excel.au3" (656) : ==> The requested action with this objec