Error in QC with Excel : "compile error in hidden module: CTDServer"

Error#1 :

I try to export tests from Excel (2003 SP 3)
to Quality center 9.2
I always get the error
"compile error in hidden module: CTDServer"

I alredy tried to re-install the Excel-Add-in
and the HP Quality Center Connectivity Add-in,
but no success.

I also tried opening directly
C:\Program Files\Microsoft Office\OFFICE11\XLSTART\TDExcelAddin.xla
but also no success.

Solution#1:

Title:
Error: "Compile error in hidden module: CTDServers" when using the Excel macro
Document ID:
KM177013
Product:
TestDirector for Quality Center
Version:

OS:
Unspecified
Updated:
2002-Nov-21


When using the Excel macro to export data into a TestDirector project, the following error message appears:

"Compile error in hidden module: CTDServers."

Diagnosis:The macro may not have been started properly or the appropriate library is not being used.

This can happen for TestDirector or TestDirector for Quality Center.

Solution
Open the TDExcelAddin.xla file manually and/or use appropriate COM library

Open the TDExcelAddin.xla file manually:

1. Open Excel.
2. Go to File -> Open.
3. Open your "\Program Files\Microsoft Office\Office\XLStart\TDExcelAddin.xla" file.

The problem should go away after doing this once.

If the problem still persists, then try the following:

1. Within Excel, Go to Tools -> Macro -> Visual Basic Editor.
2. Select VBAProject TDExcelAddin.xla (highlight). (please contact Mercury Interactive support for the default password)
3. Go to Tools -> References.
4. Scroll down to OTA 8.0 COM API Library (Or 9.0 depending on version of QC), move it up in the list and make sure it is selected.

This should resolve the macro error.

If the problem still persist, proceed to un-install and re-install the Excel Macro.

1. Select Start -> Settings -> Add/Remove Programs.
2. Select "TestDirector Microsoft Excel Add-in" to un-install the Excel Macro.
3. Download and re-install the Excel Macro from the TestDirector Add-in page.
********************

Also check if you have write access to the folder MAPS where the file TDExcelAddin.xla is or local admin rights.

Solutions#2:

Possible solutions :

Possible solutions:

1.. a. Open Excel.
b. Go to File -> Open.
c. Open your "Program Files\Microsoft Office\Office1x\XLStart\TDExcelAddin.xla" file.

2. Make sure that OTA COM Type Library is selected:

a. Within Excel, Go to Tools -> Macro -> Visual Basic Editor.
b. Select VBAProject TDExcelAddin.xla (highlight). (please contact Mercury Interactive support for the default password)
c. Go to Tools -> References.
d. Scroll down to OTA COM Type Library, move it up in the list and make sure it is selected.

3. Re-install the Excel Macro.

a. Select Start -> Settings -> Add/Remove Programs.
b. Select "TestDirector Microsoft Excel Add-in" to un-install the Excel Macro.
c. Download and re-install the Excel Macro from the TestDirector Add-in page.

4. Get the TDExcelAddin.xla file from a working machine and replace that of the affected machine. TDExcelAddin.xla is located at "C:\Program Files\Microsoft Office\OFFICE1x\XLStart".

Run the HP Quality Center Connectivity Add-in which provides the ota objects necessary for excell addinFixed the paths and OTA COM type Library version

Note : If none of the suggested solutions works, get the C:\Program Files\Microsoft Office\OFFICE11\XLStart\TDExcelAddin.xla file from a working machine and replace that of the affected machine.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------