Forum Discussion

synchi64's avatar
synchi64
Occasional Contributor
5 years ago

objSpread2 missing error in "excelcompare"

after installing the "Compare Excel files" (https://support.smartbear.com/viewarticle/9046/) and trying to run it, i was faced with an error saying that the "objSpred2" was missing and i can't find a...
  • AlexKaras's avatar
    AlexKaras
    5 years ago

    synchi64 :
    Hi,

     

    a) Your screenshot references ExcelCompare.tcx script extension, while the referenced help article talks about ExcelSheetCompare.tcx one;

    b) Script extensions are .zip archives, so you can open them and examine their internals to understand the source of the problem;

    c) objSpread2 variable in the ExcelCompare.tcx script extension is initialized with this line of code:

    Set objSpread2 = objExcel.Workbooks.Open(secondFile)

    So for me it looks like that Excel failed to open secondFile file and thus you got an error that objSpread2 object is required later in script extension code.

     

AlexKaras's avatar
AlexKaras
Champion Level 3
5 years ago

synchi64 :
Hi,

 

a) Your screenshot references ExcelCompare.tcx script extension, while the referenced help article talks about ExcelSheetCompare.tcx one;

b) Script extensions are .zip archives, so you can open them and examine their internals to understand the source of the problem;

c) objSpread2 variable in the ExcelCompare.tcx script extension is initialized with this line of code:

Set objSpread2 = objExcel.Workbooks.Open(secondFile)

So for me it looks like that Excel failed to open secondFile file and thus you got an error that objSpread2 object is required later in script extension code.

 

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    5 years ago

    note: If any excel sheet is open and in use when it is tried to be opened by the comparison extension, that may generate that same error.  So, make sure you've closed all copies of the excel sheet before you run the comparison.

    • BenoitB's avatar
      BenoitB
      Community Hero
      5 years ago

      BTW, this script should be improved, bad error management ;(

      • tristaanogre's avatar
        tristaanogre
        Esteemed Contributor
        5 years ago
        BenoitB wrote:

        BTW, this script should be improved, bad error management ;(

        Feel free to do so.  It's a Script Extension so it's wide open for anyone to take it and make mods to it. 🙂

  • synchi64's avatar
    synchi64
    Occasional Contributor
    5 years ago

    i figured it out, thanks to all of you, thank you very much, it turns out that the script apparently didn't installed itself properly

    • AlexKaras's avatar
      AlexKaras
      Champion Level 3
      5 years ago

      Hi,

       

      Thank you for the update and good to know that the problem is solved.

       

      > when i download the script, they don't apear as zip files, but as ".tcx" files

      Script extensions are .zip files with .tcx extension. Either open them as zip archives or change extension to .zip to examine their internals and revert back to .tcx when done.