How to set Excel 2007 SP3 to work with OTAClient for 11.52

  • KM01289262
  • 05-Dec-2014
  • 05-Dec-2014

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

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

Question

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.



Answer

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.microfocus.com/kb/kmdoc.php?id=KM01289262