objSpread2 missing error in "excelcompare"

[synchi64]

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 any fix for it, does anyone has any clue on what causes the error and how to fix it?

 

[BenoitB]

Do you have Excel or the Access database installed ?

https://www.microsoft.com/en-us/download/details.aspx?id=13255

It certainly use one of them.

As for me, used it without any problem.

[synchi64]

i do have both excel and access installed on the computer

[BenoitB]

For me that means that the second Excel to compare is either not available/found or invalid.

You can try to rebuild your own comparison to check if everything is ok

https://www.go4expert.com/articles/vb-script-compare-excel-files-multiple-t18330/

(Perhaps the script extension comes from this article)

[synchi64]

i tested both excel links, both links are correctly typed, the error occurs when the comparison starts,

as for the "rebuild your own" i'm not sure how to go about it, do i try to create a script to export from the code in the link or am i missing somthing?

[AlexKaras · Accepted solution]

@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]

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]

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

[tristaanogre]

---

@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. 🙂

[sonya_m]

Thank you for participating in this discussion everyone!

Hi @synchi64, looks like the Community has provided you with more suggestions. Were you able to solve the issue? Would be great to hear about you progress!