HOW TO RUN THE QC EXPORT TO EXCEL MACRO IN EXCEL 2007
0. pre-requisit a. Unzip the 447923-QC2Excel.zip file. [You can get the add-in by looking at Syaman's post from January 11, #447923. In the title bar of the post will be an Attachment link] b. Copy the QC2Excel.xla add-in file to your C:\Program Files\Microsoft Office\Office12\Library directory 1. Add the Developer Tab to your view 2. Click the Visual Basic icon in the Developer | Code tab 3. Select Tools | Macros from the VB window 4. Select QC2ExcelQC2Excel.xla) from the drop down: Macros In 5. Select the macro: ExecuteForm 6. Click Run 7. The Export to Excel Wizard will be displayed. 8. Follow the instructions in the Wizard to download your test cases.
Works great except for the html tags in the Steps fields But you can Copy\Replace those entries.
ADD DEVELOPER TAB
1. Click the Microsoft Office Button , and then click Excel Options. 2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.