Forum Discussion

MGB's avatar
MGB
Occasional Contributor
11 months ago

TestComplete Runtime Issue

Hi All, 

I am facing issue with run time error. But in my previous system i have no issue with the test run, But due to some requirements system changed. After system change i am facing issue with run time error in the line : "var Excel=getActiveXObject("Excel.Application". In this line it is showing run time error. The Log message is : "Invalid class string: Cannot obtain ClassID". Now we are using OnlyOfficeEditors software for excel. But before system change also we used same one. So kindly provide any solution for this.

 

  • rraghvani's avatar
    rraghvani
    Champion Level 3
    11 months ago

    Do you have Microsoft Excel or Office 365 with Excel installed?

    The getActiveXObject function is to get a reference to an OLE object by its name and the name of the machine where it is running. getActiveXObject("Excel.Application") is to get Excel application, which is a Microsoft product.

  • MGB's avatar
    MGB
    Occasional Contributor
    11 months ago

    Now we are using "OnlyofficeEditor" for excel

    • rraghvani's avatar
      rraghvani
      Champion Level 3
      11 months ago

      Then getActiveXObject("Excel.Application") will not work, as the product that you are using is not Microsoft.

  • MGB's avatar
    MGB
    Occasional Contributor
    11 months ago

    If we use Ms Excel, the error occuring in some other line. 

     

    • Babulu's avatar
      Babulu
      Contributor
      11 months ago

      Hi please install the AccessDatabaseEngine_X64 or AccessDatabaseEngine_X32 and try it will work

      • MGB's avatar
        MGB
        Occasional Contributor
        11 months ago

        OLE DB configuration  we did

         

      • MGB's avatar
        MGB
        Occasional Contributor
        11 months ago

        You can find the error log image in the attachment