Jump to content

sheetRowsNum error


Recommended Posts

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:

image.png.20634783e5579b2ed47b91b5ec40c4a8.png

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...