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.