About Vishwamitra Mishra

My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor’s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.
Thanks for visiting my blog.

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

Implicit and Explicit declaration of variables in VBA

Hello friends,   In the Article related to variables in VBA, I had explained following things: 1. What is Variable ? 2. Importance of Variable in Excel Programming 3. Important Rules of Variables, you must know, before declaring a Variable 4. Different Types of Variables 5. How to Declare / Initialize and Assign value to a variable 5. Scope and [...]

How to insert Outlook Signature in Email by Excel VBA

In this Article you are going to learn how to insert Outlook Signature in outlook email while sending an email via Excel VBA. It means while sending an email from Outlook via Excel Macro, if you want already saved signature to be inserted at the end of your email, then here is the code to do so.  

By |Categories: Excel Macro|Tags: , , |12 Comments

Pivot Table Tutorial : Make Pivot Table in 15 Seconds

Hi friends, In the previous article of Pivot Table, I had explained basics about Pivot table and how to make a pivot table in Excel. This is just an extension to that article. Here I have created a Shortest video to show How to create Pivot table in Excel. Watch the below video and you learn how to make Pivot [...]

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

Library not registered – Automation error

Dear Friends, I had installed Office 2007 in my system. After that I installed the trial version of Office 2013 in my system. There are so many new features in this version. Really great one. You can also try installing the trial version of Office 2013 in your system by clicking on the below image:   This article [...]

By |Categories: Excel Macro|Tags: |2 Comments

How to Send more than one Sheet of the workbook in mail

In previous article of Send Email Tutorial using Excel Macro, you learnt how to send One Sheet (Active Sheet) as attachment in the email. In this Article you are going to learn how to send more than one Sheet from a workbook as an attachment in Email. The below function sends two sheets Sheet2 and Sheet3 of the current workbook [...]

Page 10 of 20« First...89101112...20...Last »