Forum Discussion

ADHDude's avatar
ADHDude
New Contributor
6 years ago

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
    6 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

Marsha_R's avatar
Marsha_R
Moderator
6 years ago

Who knows what Microsoft did between those versions, could be anything.

 

Why not just add a step in your test to handle the dialog box?

 

 

  • LinoTadros's avatar
    LinoTadros
    Community Hero
    6 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

    • AlexKaras's avatar
      AlexKaras
      Champion Level 3
      6 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).