E-PC: OLE PeopleCode Fails with "OLE Automation error in Workbooks.OPEN: ObjectDoMethod: Unable to get the Open property of the Workbooks class" on 64 Bit Servers (Doc ID 1315663.1)

Last updated on FEBRUARY 20, 2024

Applies to:

Symptoms

Running OLE PeopleCode fails on 64 Bit Servers (Application Servers or Process Schedulers) with the following error:

OLE Automation error in Workbooks.OPEN: ObjectDoMethod: Unable to get the Open property of the Workbooks class

The issue can be replicated with the following steps:
1. Execute the following PeopleCode on a 64 Bit Server(Application Server or Process Scheduler):
Local object &oWorkApp, &oWorkBook;
  &oWorkApp =
CreateObject("COM", "Excel.Application");
  &oWorkBook =
ObjectGetProperty(&oWorkApp, "Workbooks");
ObjectDoMethod(&oWorkBook, "OPEN", "c:\temp\ppg1.xls");
2. Execute the Application Engine on a Process Scheduler running on Windows 2008 64Bit
3. The AE errors out with "OLE Automation error in Workbooks.OPEN: ObjectDoMethod: Unable to get the Open property of the Workbooks class"

Working Condition:
Running the same code on App Designer / Windows XP works.
When run in background via Windows Service it would only show in Event Viewer.
It can be called both in online PC code and in batch PC code from AE.

Changes

Cause

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