EGL: ExcelToCI2007.xlsm or Spreadsheet Journal Import(JRNL1) Encountered "Run-time Error '438'" After Latest Microsoft Patches

(Doc ID 1954601.1)

Last updated on MARCH 30, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.8 to 9.2 [Release 8.8 to 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------

When attempting to open Excel to CI Utility (Component Interface file ExcelToCI2007.xlsm) or Spreadsheet Journal Import utility encountered run time error.

Error:
------
With Excel to CI Utility - Run-time error '438' message stating 'Object doesn't support this property or method'

With Spread Sheet Import - It freezes and buttons does not appear (like new, edit etc, basically all ActiveX Controls)

Steps To Replicate:
-----------------------
Open any Excel to CI Utility (Component Interface file ExcelToCI2007.xlsm) or spreadsheet journal import utility (jrnl1.xlsm or jrnl1.xls).

Changes

 Errors encountered after most recent Microsoft Security Patches were applied.

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