Forum Discussion

csachanandani's avatar
csachanandani
Occasional Contributor
2 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
Champion Level 3
2 years ago

Ensure there's no other instances of Excel running. 

 

Also, I've just noticed, your path is not using double back slash. It should be like,

Excel.Open(fileLocation + "Test Data\\DataSheet.xlsx")

// OR

Excel.Open(fileLocation + "\\Test Data\\DataSheet.xlsx")

 

  • csachanandani's avatar
    csachanandani
    Occasional Contributor
    2 years ago

    \\ or \ doesnt matter as it picks correct path. And no excel app is running in background. I am clueless why it is not working. It randomly works and then stops.