nigmamun Posted March 28, 2023 Share Posted March 28, 2023 Hello dears, i get this error and compleatelly do not know how to fix this, because i used this script for 1 year and it works fine, but after i transfered all data it seems to become broken now. This is the part of script: #include <Excel.au3> #include <File.au3> Local $oExcel = _Excel_Open() If @error Then MsgBox(0, "Cargo Sorter", "Error opening Excel: " & @error & @CRLF & "Extended: " & @extended) Exit EndIf ;Реестр 3 кв 4 кв.xlsm Local $oWorkbook = _Excel_BookOpen($oExcel,@ScriptDir & "\Реестр 3 кв 4 кв.xlsm") Local $sheetRowsNum = $oWorkbook.Sheets(1).UsedRange.Rows.Count ;MsgBox(0, '', $oWorkbook.Sheets(1).UsedRange.Rows.Count) Here is an error: Link to comment Share on other sites More sharing options...
Danp2 Posted March 28, 2023 Share Posted March 28, 2023 Are you sure that file exists in the script directory? Try checking for errors following the call to _Excel_BookOpen. Latest Webdriver UDF Release Webdriver Wiki FAQs Link to comment Share on other sites More sharing options...
nigmamun Posted March 28, 2023 Author Share Posted March 28, 2023 Thank you so much, you gave me the idea that file name can be incorrect and a found mistake in extention of excel format. .xlsm instead of .xlsx Danp2 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now