Popular Articles

This is the category all the popular articles are categorized. Interested in reading all the popular reads.. this this the place

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

How to insert a picture in excel using VBA

Dear Friends, In this article, I am going to teach you a simple VBA code, which help you in inserting a picture in Excel Sheet. I will also discuss about difference between Inserting a picture in Excel and Embedding a picture in Excel Sheet using Excel VBA. It is based on request from one of LEM reader who wants to [...]

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

Assign a Shortcut Key using Excel VBA

Dear LEM Readers,   In the previous article, you learnt how to assign or modify a shortcut key using excel option. In this article you will learn how to assign shortcut keys to your already written procedure or subroutine using VBA (excel macro). At the end of this article you will be comfortable enough with association shortcut keys for your [...]

How to assign a Shortcut key to a Procedure or Subroutine

Dear LEM (Learn Exel Macro) Readers, It's been long time I wrote any article or answered any of your queries. Apologies for the delay in response. I am back with many more amazing articles now. All your un-answered questions will be answered in few days with a set of few interesting articles which will make you awesome in excel VBA [...]

Download : Excel Macro Application to Send Multiple Emails – 2.0

Hello Friends,   I got many good response on the tool - Send Multiple Email Workbook. I also got request to implement many other functionality as well. Attachment was one of them. In this version I have added the attachment functionality with some other small fixes. Download the latest file from the end of this article and let me know [...]

Send Sheet as a PDF attachment in Email

Dear Readers,   In my previous article, you saw how to save an Excel Sheet as PDF file. Now you know, how to save an Excel Sheet as a pdf. Also, we have seen how to send the ActiveSheet as an attachment in Email. In this article I am going to show you how to send the ActiveSheet as an [...]

How to Export an Excel Sheet as PDF file

Dear Readers, In this article you are going to learn How to save an Excel Sheet as pdf file. Many a times we generate certain reports in an Excel Sheet but while sending that report to your boss, you want that to be saved in a PDF form. In such case you can simply save your Whole Sheet or a [...]

What is Pivot Table ?

As you know Excel has so many excellent features in it. Pivot Table is one of them. If you use Microsoft Excel and not used Pivot Table, It means you have missed a really great feature of Excel. Pivot table is the best tool available in Excel to Sort, Filter, Count, Sum and summarizing the data in a worksheet. A [...]

Page 3 of 612345...Last »