This random error is seriously breaking my automated efforts.
Long story short: I read in test data with excel spreadsheets. Quite often it will break on this line here:
Set ExcelFile = ExcelCore.Workbooks.Open(FileToUse)
All it is doing is opening up an excel workbook. Nothing more, nothing less. I've tried using local files instead of networked files, everything. It happens on multiple computers. TestComplete's excel-based DDT support is inadequate.
I'm using MS Office Excel 2007. Has anyone else ran into this error? I've googled to no avail. I'm really stumped on this one.
Excelcore is the object declaration:
Set ExcelCore = Sys.OleObject("Excel.Application")
For what I'm doing on reading excel sheets, I might not know the sheet name. You can't enumerate sheets with the DDT support. Also want to be able to use multiple sheets. I gave it an honest try with DDT and it gave back a lot of "undefined"s for values.