The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:




Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Testing Tools >> HP ALM / Mercury Quality Center

wjones
Newbie


Reged: 07/10/09
Posts: 2
Re: How to export tests from QC to excel
      02/23/10 11:59 AM

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.

Post Extras Print Post   Remind Me!     Notify Moderator


Entire topic
Subject Posted by Posted on
* How to export tests from QC to excel nikki_qa 11/18/07 06:05 AM
. * * Re: How to export tests from QC to excel 03471A0227   05/08/12 12:04 PM
. * * Re: How to export tests from QC to excel proximityinfo   06/24/10 01:01 AM
. * * Re: How to export tests from QC to excel Syaman   01/10/08 07:03 AM
. * * Re: How to export tests from QC to excel Tony Davis   01/10/08 09:21 AM
. * * Re: How to export tests from QC to excel Cuthbert   01/10/08 01:16 PM
. * * Re: How to export tests from QC to excel Syaman   01/11/08 02:49 AM
. * * Re: How to export tests from QC to excel Ronaldo121   03/17/08 06:04 AM
. * * Re: How to export tests from QC to excel AuradisWorld   03/23/12 08:50 PM
. * * Re: How to export tests from QC to excel Syaman   03/21/08 07:36 AM
. * * Re: How to export tests from QC to excel jirlbeck   01/12/11 07:39 AM
. * * Re: How to export tests from QC to excel qa_answer_seeker   08/12/10 07:23 PM
. * * Re: How to export tests from QC to excel arkay15   08/16/10 05:38 PM
. * * Re: How to export tests from QC to excel MrAnonGuy   03/18/08 09:08 AM
. * * Re: How to export tests from QC to excel arkay15   08/18/10 06:24 PM
. * * Re: How to export tests from QC to excel Syaman   01/11/08 05:28 AM
. * * Re: How to export tests from QC to excel Venugajendra   02/15/08 06:16 AM
. * * Re: How to export tests from QC to excel Syaman   03/21/08 08:03 AM
. * * Re: How to export tests from QC to excel lisapayneabreu   07/30/08 11:40 AM
. * * Re: How to export tests from QC to excel kushwaaj   02/08/10 01:01 AM
. * * Re: How to export tests from QC to excel Syaman   01/11/08 05:29 AM
. * * Re: How to export tests from QC to excel itssri   01/11/08 01:17 PM
. * * Re: How to export tests from QC to excel ambience   01/14/08 02:28 PM
. * * Re: How to export tests from excel to qc Saaz   01/15/08 09:54 PM
. * * Re: How to export tests from excel to qc Saaz   01/21/08 12:51 AM
. * * Re: How to export tests from excel to qc dovi   01/21/08 02:58 AM
. * * Re: How to export tests from qc to excel Saaz   01/21/08 03:06 AM
. * * Re: How to export tests from excel to qc dovi   01/21/08 03:09 AM
. * * Re: How to export tests from qc to excel Saaz   01/21/08 03:36 AM
. * * Re: How to export tests from excel to qc dovi   01/21/08 03:45 AM
. * * Re: How to export tests from excel to qc dovi   01/21/08 03:47 AM
. * * Re: How to export tests from qc to excel Saaz   01/21/08 04:03 AM
. * * Re: How to export tests from QC to excel Syaman   01/15/08 08:10 AM
. * * Re: How to export tests from QC to excel ambience   01/21/08 08:41 AM
. * * Re: How to export tests from QC to excel Amulyaraag   01/19/11 05:27 PM
. * * Re: How to export tests from QC to excel biggi   05/26/10 02:54 PM
. * * Re: How to export tests from QC to excel genevish   05/24/10 01:35 PM
. * * Re: How to export tests from QC to excel Syaman   03/21/08 07:02 AM
. * * Re: How to export tests from QC to excel wjones   02/23/10 11:08 AM
. * * Re: How to export tests from QC to excel wjones   02/23/10 11:59 AM
. * * Re: How to export tests from QC to excel suny10   02/24/10 09:05 PM
. * * Re: How to export tests from QC to excel Jonty   02/25/10 12:20 AM
. * * Re: How to export tests from QC to excel -Asher-   02/25/10 12:34 PM
. * * Re: How to export tests from QC to excel -Asher-   03/01/10 07:34 PM
. * * Re: How to export tests from QC to excel BigSimmo   02/17/11 02:06 PM
. * * Re: How to export tests from QC to excel -Asher-   02/17/11 06:59 PM
. * * Re: How to export tests from QC to excel rmcginnis   02/25/10 02:38 PM
. * * Re: How to export tests from QC to excel suny10   02/25/10 08:20 PM
. * * Re: How to export tests from QC to excel michaeltewierik   02/28/10 04:37 PM
. * * Re: How to export tests from QC to excel Tammi   06/23/10 06:25 AM
. * * Re: How to export tests from QC to excel jnlp   05/24/10 01:33 AM
. * * Re: How to export tests from QC to excel Blue_Motorcycle   02/07/08 12:32 PM
. * * Re: How to export tests from QC to excel Saaz   02/07/08 04:17 AM
. * * Re: How to export tests from QC to excel Tony Davis   02/07/08 06:52 AM
. * * Re: How to export tests from QC to excel Saaz   01/21/08 11:06 PM

Extra information
0 registered and 21 anonymous users are browsing this forum.

Moderator:  Rich W., AJ, jgottlieb 



Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Thread views: 47483

Rate this thread

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5