FREE Download : Send Multiple Email Tool – Ver 3.0

Dear Readers,   First of all, I would like to thank you all for appreciating and giving the feedback about Send Multiple Email – VBA Tool. I have come up with the next version of the same tool based on your suggestions and feedback. I promise, this version is going to amaze you with it’s [...]

Spreading an Array values across Rows in Excel – VBA

Hello friends,   This is an extension to my previous Article. Where we learnt a best way to spread an array values across columns in Excel. Here I will teach you how to spread an Array values across Rows in Column. How it works? How it is different from the previous code? In the previous [...]

Spreading an Array values across Columns in Excel – VBA

All my avid readers from Computer Programming background must be thinking is it a big deal? Like other programming languages use loop to traverse all the values of an array and spread them across rows or column. Right?   If you are thinking so… you are absolutely right. You can do it using loop.   [...]

Download Free Add-in – File Manager

Dear LEM Readers,   It’s been long time since I wrote any article here. I was really busy in some personal work and apology for not making it. Now I am back with some more tutorials, articles, tools and Add-ins.   Here is the first Add-in which I built it for you to make your [...]

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 [...]

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 [...]

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 [...]

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

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 [...]



  • About
  • Downloads
  • Excel Formula
  • Excel Tips
  • Excel Macro Tutorial
  • VBA Functions
  • Archives
  • Contact
  • Excel Formula
  • Excel Functions
  • Excel Macro
  • Excel Macro Basics
  • Excel Macro Tutorial
  • Excel Tips
  • HP QC
  • Interesting VBA Functions
  • New to Excel Macro ?
  • Personal
  • Popular Articles
  • 2014
  • 2013
  • 2012
  • 2011