IBM Support

CognosOfficeAutomationObject() does not identify the Microsoft Excel version for some locales

Troubleshooting


Problem

When using some Microsoft Windows locales, the automation function CognosOfficeAutomationObject() does not identify the Microsoft Excel version. This can cause VBA processes to stop.

Symptom

When you run a VBA process in Cognos Analysis for Microsoft Excel, the process steps out at the following line in the CognosOfficeAutomationObject() function:

If CDbl(Application.Version) < 12 Then

The problem occurs only for some Windows locales. Your Windows locale is set in Control Panel->Region and Language.

Cause

CDbl(Application.Version) is invalid in some locales. This is a Microsoft issue.

Environment

Microsoft Excel 2013 64-bit and 32-bit

Microsoft Excel 2010 64-bit and 32-bit

Microsoft Excel 2007

Resolving The Problem

Change CDbl(Application.Version) to Val(Application.Version)

[{"Product":{"code":"SSHM9K","label":"Cognos Analysis for Microsoft Excel"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Analysis for Excel","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21964220

Page Feedback