Forum Discussion

ADHDude's avatar
ADHDude
New Contributor
5 years ago
Solved

Microsoft Excel issue

Good morning,   Just wondering if anyone has experienced this before or knows what is going on...   Currently, we are using runner machines that are on Windows 7 OS along with Excel 2013. We ...
  • LinoTadros's avatar
    LinoTadros
    5 years ago

    Yes that is a known issue in automation for Excel

    Opening a 2013 file in 2016, even you if don't change anything, will cause Excel to bring up a box stating that the you have to accept that the file will be saved in the new 2016 format.

     

    My recommendation is to save the files as 2016 files once before you start the COM automation with Excel from inside of TestComplete

    Cheers

    -Lino

LinoTadros's avatar
LinoTadros
Community Hero

Yes that is a known issue in automation for Excel

Opening a 2013 file in 2016, even you if don't change anything, will cause Excel to bring up a box stating that the you have to accept that the file will be saved in the new 2016 format.

 

My recommendation is to save the files as 2016 files once before you start the COM automation with Excel from inside of TestComplete

Cheers

-Lino

AlexKaras's avatar
AlexKaras
Champion Level 3
5 years ago

Hi,

 

Depending on how you are reading Excel file, I hope that there might be an option to command Excel to close file ignoring changes (and thus do not display any dialog).