E-ExcelToCI: Getting "Runtime Error '438'" Opening ExcelToCI Spreadsheet After Installing December Microsoft Windows Updates Or Installing Lync 20XX (Doc ID 1953931.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 to 8.54 [Release 8.4]
Information in this document applies to any platform.

Symptoms

Customers see the following error when opening the ExcelToCI spreadsheet. In most cases the error is seen after installing the latest Microsoft Windows Updates in early December 2014, while in other cases it is seen after installing Microsoft Lync 20XX (for example, Lync 2013).  

"Run-time error '438':
Object doesn't support this property or method"

If the user clicks on Debug, the debugger opens the line of code below (in the Private Sub Workbook_Open()).

'Initialize btnProtocol
Sheets(sSheet2).btnProtocol.Clear

 

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