Yearly Archives: 2012

Merry Xmas to you All – 2012

Dear Friends, Wishing you a very very happy Christmas to you all. May God bless you all with tons of happiness and love. Enjoy !! Merry Christmas      

By |Categories: Personal|Tags: , |0 Comments

Get Special Folder Path using VBA

Hello Friends,   In this article I am going to explain you how to get the path of Special Folders in Windows Operating System. Using VBA we can get path of Special folders path like, Desktop, My Documents, Library etc. Few important special folders are listed below. There are many more special folders available but I am putting code for [...]

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

How to display Input message on selecting a cell in Excel

Dear Friends, In this article I am going to explain you.. How you can display a message as soon as on selecting a cell. Most importantly here you need not write any VBA code to do so. When I say it is an input message, it is not a message box or input message box. It is like comment in [...]

By |Categories: Excel Functions|Tags: |0 Comments

Happy Diwali – 2012

Dear Readers, Wish u and your family a very happy Diwali and a prosperous new year. May God fulfill all your wishes in wealth, health and happiness in your life. May this festival of lights brings all happiness and prosperity in your life. Wish you a very happy Diwali

By |Categories: Personal|Tags: , |0 Comments

Important : Declaring multiple Variables with one Dim Statement

Hello friends,   As you know in VBA variables are declared using Dim Statement. You have also learnt about how to declare a variable in VBA in the previous articles. You have also learnt about Implicit and explicit option variables.   Here is a question: In below image there are two ways of declaring three variables VAR1, VAR2 and VAR3 [...]

VBA Programming : Decision – Select Case

Hello friends in the last article of VBA Programming Tutorial you have learnt the use of If..else statement. In this lesson you are going to learn another decision making statements in VBA. It means it is another way to control the flow of program, that is nothing but Select... Case structure.   Syntax:   Select Case <test_expression>     Case <condition_1>       <Your code [...]

Page 1 of 712345...Last »