Forum Discussion

subbu_valliappa's avatar
subbu_valliappa
Contributor
11 years ago

Excel file causes serious error when opened during TestComplete runs

In our TestComplete scripts that we run overnight, a particular script is setup to open Excel spreadsheet and copy its data. It has been running alright until lately when we have noticed an unexpected...
  • murugans1011's avatar
    murugans1011
    11 years ago
    The issue occurs when the excel workbook is not closed property by terminating the excel application and opening the same file again and  the issue is related to excel application. may be try the following solution



tristaanogre's avatar
tristaanogre
Esteemed Contributor
11 years ago
Is it possible that you are opening the file during your scripts but then failing to close it properly?  It may be that the "error" being reported is some sort of improper exit or closure of the Excel process in windows.  Double check to make sure that, once your script is finished with the Excel spreadsheet, it is closing it properly.