Forum Discussion

csachanandani's avatar
csachanandani
Occasional Contributor
3 years ago

TestComplete started failing tests that read data from Excel with Macros

I had TestComplete tests that would read data from excel with macros and now have started receiving "Excel internal error 'Element not found'." when I started running them now. Has anyone ever experi...
rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
3 years ago

Is it reading the correct file? And is the dialog about giving permissions to run Excel Macros preventing the file from being read?

  • csachanandani's avatar
    csachanandani
    Occasional Contributor
    3 years ago

    Yes, it reads file location, the file has all correct permissions - no changes on that, and then fails at the excelFile = Excel.Open(fileLocation+"Test Data\DataSheet.xlsx") line. Hard time understanding why the tests are failing.