Self-Solve Knowledge Search

Minimize Maximize
How to set Excel 2007 SP3 to work with OTAClient for 11.52
This document has not been formally reviewed for accuracy and is provided as is
Title :
How to set Excel 2007 SP3 to work with OTAClient for 11.52
Document ID :
KM01289262
Product - Version:
quality center 11.52 ;
OS :
Updated :
Fri Dec 05 09:35:29 GMT 2014
Summary :
As Microsoft Office 2007 SP3 is not supported for ALM our client found a workaround how it can work with ALM 11.52 patch 04

As Microsoft Office 2007 SP3 is not supported for ALM our client found a workaround how it can work with ALM 11.52 patch 04.

 

1.       Make sure that the references before the executing code in the VBA project have been set correctly as described in the attached document MS_Office_2007_SP03_OTA_ALM115X_Required_References.

2.       Within the VBA project, add “Option Explicit” in one of the public functions within a module and save the modified VBA project.

3.       Execute the VBA code by initiating one of the features, triggering the execution error stating that “Option Explicit” has been used incorrectly.

4.       Remove the faulty “Option Explicit” and save the VBA project again.

 

After that all functions calling the new OTAClient will be running properly on ALM 11.52 Patch 04.



Solution
Client porvided us with a workaround how to set Excel 2007 SP3 to work with OTAClient for 11.52
As Microsoft Office 2007 SP3 is not supported for ALM our client found a workaround how it can work with ALM 11.52 patch 04.

1. Make sure that the references before the executing code in the VBA project have been set correctly as described in the attached document MS_Office_2007_SP03_OTA_ALM115X_Required_References.
2. Within the VBA project, add “Option Explicit” in one of the public functions within a module and save the modified VBA project.
3. Execute the VBA code by initiating one of the features, triggering the execution error stating that “Option Explicit” has been used incorrectly.
4. Remove the faulty “Option Explicit” and save the VBA project again.
After that all functions calling the new OTAClient will be running properly on ALM 11.52 Patch 04.
Please also consider visiting the web-based version of this response at:
http://support.openview.hp.com/selfsolve/document/KM01289262