Monthly Archives: September 2013

HP Quality Center – Excel Macro to Import Test Cases from QC

Dear LEM Reader's,   In this article I am going to share VBA code to download the test cases from QC in Excel Sheet. Here in this example, I will fetch very few important fields from QC but if you want more fields to be fetched then it can be easily done. I have categorized this VBA code in to [...]

HP Quality Center – Check if Connection to QC is made successfully ?

Hello Friends,   This article is basically an extension to my previous article How to Connect to HP QC using Excel VBA. As we know, from the previous article that QC Connection is made in two parts:   1. Authentication using QC ID and Password 2. Login with Domain and Project Name   It is a good practice to check [...]

Excel Tip : How to save an Excel Addin (.xla) to Excel Workbook(.xls)

Hello Friends,   This is a small excel tip to convert a .xla or .xlam file to .xls or .xlsm file. This is a simple trick but really tricky one. Follow the below Steps to do the same:   Double Click on .xla or .xlam file (Refer Pic 1)     File will open as shown in the below Pic [...]

HP Quality Center – Create Folder Structure in Test Lab and Pull test Cases from Test Plan

Dear LEM Readers,   In previous article, we learnt How to connect to HP QC using Excel Macro. In this article we are going to learn How to create folder structure in HP QC Test Lab. As you must be knowing - To show the test execution in Test Lab you should follow below steps:   Step 1. Create folder [...]

HP Quality Center – Connect to HP QC using Excel VBA

Dear LEM visitors, This is the first article of HP QC VBA Tutorial. Here I will teach you the first step which you should know before doing any automation related to Quality Center using Excel Macro. That first step is nothing but connecting to the Quality Center using excel macro. As you might have seen on the Quality Center UI [...]

Email ID Syntax Validation in Excel

Dear LEM users,   I got quite a few questions regarding How to enforce Email ID syntax validation in Excel. It could be in a particular cell or any textbox etc. So i thought of putting this small excel VBA tip which may help a lot in enforcing this validation. This small validation trick will make your excel intelligent and [...]