Excel functions not working on new PC

[nmellis]

Hi all, I am a novice user, but have been using an AutoIT script for laboratory automation for a couple of years now. The script in question has worked fantastically for 2 years, but we just got a new computer that it is no longer working correctly on for some unknown reason.

The bit of code that is broken on the new machine is the following function:

Func DeleteSampleQueue()
    ;;deletes the first line in the sample queue spreadsheet
    Local $oExcel = _Excel_Open()
    Local $oWorkbook = _Excel_BookOpen($oExcel, "R:\Sample Queue\Clumped Sample Queue.xlsx")
    Local $sRange = $oWorkbook.ActiveSheet.rows(2)
    _Excel_RangeDelete($oWorkbook.ActiveSheet, $sRange)
    _Excel_BookSave($oWorkbook.ActiveSheet)
    _Excel_Close($oExcel, Default, True)
EndFunc

When the code tries to manipulate the Excel workbook, I get the following error: 

(33) : ==> Variable must be of type "Object".:
Local $sRange = $oWorkbook.ActiveSheet.rows(2)
Local $sRange = $oWorkbook^ ERROR

I verified that it works as intended on the old machine. Both machines are running the exact same versions of Excel 2016 (32 bit) and AutoIT (3.3.14.5; 32 bit).

I am stumped. If anyone has any ideas on how to resolve this, please let me know!

[Subz]

Try to add some error handling to see where the issue is coming from see _Excel_BookOpen for an example

 

[nmellis]

Thank you for your suggestion. This gave me a better idea of what was happening and I figured out the problem! Thank you!

[water]

And the problem was?