Forum Discussion

Vinod_Gulia's avatar
Vinod_Gulia
New Contributor
8 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...
Vinod_Gulia's avatar
Vinod_Gulia
New Contributor
8 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
8 years ago

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