Forum Discussion

synchi64's avatar
synchi64
Occasional Contributor
5 years ago
Solved

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

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.

 

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.