prasadstudy Posted September 8, 2017 Share Posted September 8, 2017 Link to comment Share on other sites More sharing options...
prasadstudy Posted September 8, 2017 Author Share Posted September 8, 2017 5 minutes ago, prasadstudy said: I am getting the following error "Variable must be of type object" while running the below small program #include <Excel.au3> Global $WorkbookPath="File path" Global $OpenExcel=_Excel_Open() Global $OpenWorkBook=_Excel_BookOpen($OpenExcel,$WorkbookPath) Global $xlup = -4162 Global $iRow = $OpenWorkBook.ActiveSheet.Range("B65536").End($xlup).Row Global $var[$iRow] Global $i=0 Global $r=2 For $i=($iRow-$iRow)+1 To $iRow-1 $var[$i]=_Excel_RangeRead($OpenWorkBook,1,"B"&$r) Send($var[$i]) $r=$r+1 Next I did lot of googling to fix the issue but so far no success. Also this small script was working fine in the past but stopped from yesterday. Any assistance to fix this issue would be greatly appreciated. Link to comment Share on other sites More sharing options...
water Posted September 8, 2017 Share Posted September 8, 2017 You need to add some error checking to your script. Does any of the _Excel* functions set @error or @extended? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
prasadstudy Posted September 8, 2017 Author Share Posted September 8, 2017 Hi Water, I have not added any error checking in _Excel* functions. Thanks! Link to comment Share on other sites More sharing options...
prasadstudy Posted September 8, 2017 Author Share Posted September 8, 2017 20 minutes ago, prasadstudy said: Hi Water, I have not added any error checking in _Excel* functions. Thanks! 20 minutes ago, prasadstudy said: Hi Water, I have not added any error checking in _Excel* functions. Thanks! 20 minutes ago, prasadstudy said: Hi Water, I have not added any error checking in _Excel* functions. Thanks! 20 minutes ago, prasadstudy said: Hi Water, I have not added any error checking in _Excel* functions. 20 minutes ago, prasadstudy said: Hi Water, I have not added any error checking in _Excel* functions. Thanks! This works fine after making correction in excel file path. Thanks!!!! 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