Forum Discussion

Vinod_Gulia's avatar
Vinod_Gulia
New Contributor
6 years ago

Compare Excel files - Object required: 'ExcelObj' (Run time error)

I've installed ExcelSheetCompare script extension and using the below mentioned code snippet taken from https://support.smartbear.com/viewarticle/9046/   Sub Main Dim oExcel, aSheets, vSheet, f...
tristaanogre's avatar
tristaanogre
Esteemed Contributor

In that code, which line is generating the error?

One thing I see potentially wrong (haven't tried it), you're adding the "Data" sheet to the aSheets dictionary twice.  Remove the second instance of 

 

vSheet = "Data"

Call aSheets.Add(vSheet, vSheet)

and try again.

Vinod_Gulia's avatar
Vinod_Gulia
New Contributor
6 years ago

Hi,

 

Exception is thrown at following line of code: -

Set aInfo1 = ExcelObj.CreateInfo(oExcel, fileName, aSheets)

 

Call aSheets.Add(vSheet, vSheet) seems correct. Key as Object and Item as Object get added into Dictionary.

 

 

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    6 years ago

    Right, it's correct... but you have it added twice.  Remove the second instance of the code to add to the aSheets.

  • Pbleu's avatar
    Pbleu
    New Contributor
    6 years ago

    Ensure TestComplete sees the extension and it is enabled (may need to do a "Reload" on the File->Install Script Extension).  I downloaded the extension and placed it under <TestComplete xx root>\bin\Extensions\ScriptExtensions for my test.  If you have "auto-complete" enabled, the script object will appear in the pop-up when you type "Ex" or after "ExcelObj." you should be able to select either of the two functions.  You should also delete the "\" in your filename string, it is not needed (Project.path typically returns a string with an ending "\")