Unhandled Exception Errors When Making COM Calls to Microsoft Excel (Doc ID 1678397.1)

Last updated on JULY 11, 2017

Applies to:

Siebel CRM - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.

Symptoms

When attempting to format an Excel document via COMCreateObject("Excel.Application"), some functions that were working on 8.1.1.9 are not working under IP2013 and IP2016.

ERROR
-----------------------

5. Make sure the XLSX file is placed in the corresponding path (C:\Siebel\Logs)
6. Click RUN

***************
RESULTS | FINDINGS:

ERROR: Unhandled Exception: '_getElement' is not defined
Service.ExcelTest2 line: 76
Service.Service_PreInvokeMethod line: 112
Service.ExcelTest2 line: 86
Service.Service_PreInvokeMethod line: 112
Service.ExcelTest2 line: 103
Service.Service_PreInvokeMethod line: 112

ISSUE: 'aRange' comes as undefined.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms