I am using the following code to compare two Excel files:
Set oExcel = Sys.OleObject("Excel.Application")
Set aSheets = Sys.OleObject("Scripting.Dictionary")
oExcel = .OleObject("Excel.Application") aSheets = .OleObject("Scripting.Dictionary")
fileName = "<C:\Test238>"
Set aInfo1 = ExcelObj.CreateInfo(oExcel, fileName, aSheets)
fileName = "<C:\Test>"
Set aInfo2 = ExcelObj.CreateInfo(oExcel, fileName, aSheets)
oResult = ExcelObj.Compare(aInfo1, aInfo2)
If Len(oResult) > 0 Then
Log.Warning oResult
Else
Log.Message "The files are the same."
End If
oExcel.Quit
I keep receiving the attached error message.