SorryButImaNewbie

_ExcelRangeFind error in line 656

2 posts in this topic

#1 ·  Posted (edited)

Good day everyone!

I'm having a problem with my underconstruction excel script (again... , sorry haven't used autoIT for a while, pretty sure this is a basic error as well)

If $xls2 = 1 Then
        $ExcelName = $aWorkBooks[2][1]
        $ExcelPath = $aWorkBooks[2][2]
        MsgBox($MB_SYSTEMMODAL, "Excel", " Excel file path: " & $ExcelPath)
        MsgBox($MB_SYSTEMMODAL, "Excel", " Excel file name: " & $ExcelName)
    EndIf

    If $xls3 = 1 Then
        $ExcelName = $aWorkBooks[3][1]
        $ExcelPath = $aWorkBooks[3][2]
        ;MsgBox($MB_SYSTEMMODAL, "Excel", " Excel file path: " & $ExcelPath)
    EndIf


$ExcelObject = _Excel_BookAttach($ExcelName, "filename")
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookAttach Example 2", "Error attaching to '" & $ExcelObject & "'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookAttach Example 2", "Search by 'filename':" & @CRLF & @CRLF & "Successfully attached to Workbook '" & $ExcelObject & "'." & @CRLF & @CRLF & "Value of cell A2: " & $ExcelObject.Activesheet.Range("A2").Value)


$knkod = _Excel_RangeFind($ExcelObject, "knkod")
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeFind Example 1", "Error searching the range." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeFind Example 1", "Find all occurrences of value 'knkod' (partial match)." & @CRLF & "Data successfully searched.")
_ArrayDisplay($knkod, "Excel UDF: _Excel_RangeFind Example 1", "", 0, "|", "Sheet|Name|Cell|Value|Formula|Comment")

I ask my users, to only run one excel instances while starting my script (so I can develope a simple a script I can, and then upgrade it once I code like i was able to, once again...), thats why I dont use UBound but give an array of 4 for possible running excel detection. If its needed I can easly add to array size for now.

I check for given file extensions and also have an error+exit if I found more then 1 running excel. Of course I know that my code is pretty childish for now.

I use Excel_BookAttach to attach to the excel object, the script succesfully run, and gives back the value of A2 cell (code basicly copy pasted from help file) but then I get an error in the console that reads:

--> Press Ctrl+Alt+Break to Restart or Ctrl+Break to Stop
"C:\ToolBox\AutoIT\AutoIt3\Include\Excel.au3" (656) : ==> The requested action with this object has failed.:
$aResult[$iIndex][1] = $oMatch.Name.Name
$aResult[$iIndex][1] = $oMatch^ ERROR
->17:53:47 AutoIt3.exe ended.rc:1
+>17:53:47 AutoIt3Wrapper Finished.
>Exit code: 1    Time: 24.24

(sorry if i should have wrote this some other way)

I suspect that I screw something up with the workbook/worksheet handling or that $ExcelObject isn't an object somehow. I'm not sure, but IsObj return 1 if i check $excelobject

Edit: Maybe there is some kind of problem with the name of the excel? It has "á" in it's name, could that be a problem?

Thank you for your insight! and sorry for the elementary questions

Edited by SorryButImaNewbie
forgot something from the original post

Share this post


Link to post
Share on other sites



It's a bug in AutoIt 3.3.14.2 with COM error handling.
If you search the forum for this bug you will find a few hits.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Similar Content

    • breakbadsp
      By breakbadsp
      I  want to create a excel file from my script if it does not exist.
      _ExcelBookOpen throws error=2 if file does not exist, after this error i want to create new file at this point.
      can i use _FileCreate()?
      _Logger($sLogPath, "{INFO}------: Opening Excel File: " & $sExcelPath& "") While 1 Local $oExcelTestResult = _ExcelBookOpen($sExcelPath) If @error = 2 Then If not _FileCreate($sResExcelPath) Then MsgBox(0, "Error", "Error In Opening REsult Excel File: Error: " & String(@error)) _Logger($sLogPath, "{ERROR}------: Result Excel File does not exist.. tried to create new but :ERROR : " & String(@error) & "") ExitLoop Else _Logger($sLogPath, "{INFO}------: Result Excel File does not exist.. **Created New**: ") EndIf Else ExitLoop EndIf WEnd  
    • LoneWolf_2106
      By LoneWolf_2106
      Hi everybody,
      i have to store an entire row of a Excel workbook into an array.  The row index is stored in a variable.
      How can i do it?
      Thanks in advance for your support.
    • LoneWolf_2106
      By LoneWolf_2106
      Hi everybody,
      i have to write a value into an excel column.
      I know where it starts from, but i don't know what the end is, last non-empty cell.
      How can i get the number of last non-empty cell?
      Thanks in advance.
      Regards 
    • Nareshm
      By Nareshm
      Hi All,
      I have excel file like this
      and i want to cut cell/text from excel to other software.

       
      I have to cut the cell of B column one by one and past into other software
      If Winexists("No Data Found")
      then restore cuted cell and goto next/down side cell
      How to do it ?
    • water
      By water
      Extensive library to control and manipulate Microsoft Excel charts.
      Theads: General Help & Support - Example Scripts
      BTW: If you like this UDF please click the "I like this" button. This tells me where to next put my development effort

      KNOWN BUGS (last changed: 2017-07-21)
      None. The COM error handling related bugs have been fixed.