Popular Articles

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

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

Mail Chart as Image from Outlook – VBA Code

In this article you will learn how to send a chart as picture using outlook from Excel Macro. As you know that in Outlook email, you can send an Image like a normal file attachment. In this case, receiver has to open the attachment to see the content. Since outlook supports HTML formatting of the email body, it is possible [...]

Download Free File Manager – New Version

Hi Friends, I had created one file manager in Excel using excel macro. Basically it lists all the Files in a folder and sub-folders of any given drive in your PC. It fetches File Name, File Path, File Size, File Type, Last Modified Date of each file and list it in the Excel. Based on some valuable inputs and queries, [...]

How to Send Email Automatically from Excel

Hello friends, In the previous Article, you learnt how to Schedule a Program in Windows. In this article you are going to learn, How can we send email from Excel on a Scheduled date and Time automatically without any manual intervention. I have taken an Example from Live Scenario, where you want to send an Email on a daily basis [...]

Page 3 of 512345