My Oracle Support Banner

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 14, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.