Yearly Archives: 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 [...]

How to insert a picture in excel using VBA

Dear Friends,   This is not a big article. It is based on request from one of LEM reader who wants to know, How to insert a selected picture in excel using VBA code It is a very simple one liner code to insert a picture in Excel using vba code.   Syntax: ActiveSheet.Pictures.Insert('full path of the picture [...]

Few very useful and small macros

Dear LEM Readers,   In this first part of this article I am going to share very small but useful vba codes which are most frequently used in day-to-day vba programming. Many of my readers had requested for them so I have clubbed all of them together and made one article :) Enjoy reading them...   Closing All Open Workbooks [...]

Check if file is already open using excel VBA

Dear LEM Readers,   While doing programming with VBA many a times it happens to open an existing file. Before opening that file, it is always a good idea to check if that file is already open or not. Therefore I have written a function (IsFileOpen()) which takes the complete path of that file (with file name) as an Input [...]

Assign a Hot Key to a Command Button in Excel

In Excel VBA you can assign a hot key for a command Button as well. It means you can assign a hot key to a command button which can be triggered by pressing that hot key from the keyboard. It means you can perform the operation either by clicking on the command button or by pressing the hot key.   [...]

Page 1 of 212