Hello

That solution you mention is a valid fix for you error message. Sometimes the OTA COM library is not selected and that can lead to your error.

To get to this in Excel 2010, and for 2007 as well, follow the below steps. Be sure you have the Excel add-in installed already for your version of QC.

First we need to enable the Developer tab in your Excel 2010.

1. On the File tab, choose Options to open the Excel Options dialog box.
2. Click Customize Ribbon on the left side of the dialog box.
3. Under Choose commands from on the left side of the dialog box, select Popular Commands.
4. Under Customize the ribbon on the right side of the dialog box, select Main tabs, and then select the Developer check box.
5. Click OK.

For 2007:

1. Add the Developer tab to the ribbon. Click the Office button, and then
click the Excel Options button. Click. Customize Ribbon on the left side of
the dialog box.
2. In the Popular category on the left
side panel, select the Show
Developer tab in the Ribbon check
box from the options that appear and
then click OK.Under Customize the
ribbon on the right side of the
dialog box, select Main tabs, and
then select theDeveloper check box.

Once the Developer Tab is visible, click on it and you will see the Visual Basic editor to the left. Also note the Macro Security link there as well, if you need to edit those settings.

Click on the Visual Basic editor to the left. This will open a new window. On the left side you will see the VBA Project list. Below should be the VBAProject (TDExcelAddin.xla). Click on that.

You will be prompted to enter a password. The default HP password for this is tdtdtd. Once entered, you should have access to the files beneath it.

Now go up to the Tools tab, with the TDExcelAddin.xla highlighted, and pick the first option which is References.

In this list is where you will find the OTA COM Type Library. Find it in the list, select it, and move the option up to the top with your other selected reference items. Once done, click OK. Exit out of the Visual Basic editor and you should now have the fix enabled that you referenced in your question.

For version 2007, the steps are the same once you have enabled the Developer tab.