nigmamun Posted March 28, 2023 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:
Danp2 Posted March 28, 2023 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
nigmamun Posted March 28, 2023 Author 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
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