Excel Macro Tutorial

Find Excel macro tutorials for beginners as well as advanced users. Find subject specific tutorials like Sending emails through VBA, using quality center through VBA etc.

Methods to save a Macro FREE copy of a workbook [FREE DOWNLOAD]

Dear Friends, This is a very simple yet powerful Excel VBA tip for you. Many a times before sending your workbook with Excel VBA Macro code in it, you want to save your workbook without any VBA code in it. Therefore here in this article, I will show you - how to save your Excel Workbook without excel macro in [...]

40 Useful Excel Macro [VBA] examples – Part 2 of 2 [ FREE DOWNLOAD ]

Dear friends, As you see this is the second and last part of the tutorial 40 Useful Excel Macro [VBA] examples. In previous article i had published the first 20 examples. Download a FREE Excel Workbook with all 40 Examples At the end of this article, you will have a link to download a FREE copy of all 40 useful [...]

40 Useful Excel Macro [VBA] examples – Part 1 of 2

Dear Friends, Here in this article, I have tried to consolidate some most useful and more frequently used excel macro with examples. This is part 1 where I have provided 20 Excel Macros related to workbook and worksheets. Remaining 20 Excel Macro examples will be followed in my next article - 40 Useful Excel Macro examples for Beginners - Part [...]

What is Immediate Window and how to use it in Excel VBA

Dear Friends, Have you heard of Immediate Window in Excel VBA programming? Do you know how to make use of it? If you have not been using this while doing vba programming then trust me you were missing something really cool stuff which excel provided to the programmers. In this article I am going to explain you the following 1. [...]

Top 4 VBA Methods to Export Excel data as CSV File

In this article, I am going to teach you 4 VBA Methods of - how to export data from Excel Range to a CSV file format using Excel VBA.

VBA Guide to Interact with Text Files – Part – 2 of 2

Dear Friends, I am back with the second part of the tutorial- VBA Guide to Interact with Text Files – Part – 1 of 2. This is the final part of this tutorial. In previous article, mainly we learn about How to Open a Text File and How to write to Text File using VBA code. There were some [...]

VBA Guide to Interact with Text Files – Part – 1 of 2

Text files are one of the simplest, lightest file types. This is the reason it is highly used in programming to store lot of configuration related data, logs and so many other necessary data which is used by programs more frequently. If you browse your Program files folder in windows almost every program will have some text files for storing [...]

Image in Signature not Displayed – Mail Sent by VBA

Dear Friends, I was keep getting this question from many of you that whenever your outlook signature has an Image then rest of the texts are displayed correctly but Image was never displayed. It was always appearing with a red cross sign (missing image) image. In order to get rid of this problem there are two solutions. outlook Signature [...]

Calculate distance between two places in Excel [With Fun]

Dear readers, Last week, As I had placed an article on how to create static google map in excel using Google Static Map API. Over this weekend, I thought of creating some fun for you in Excel using Google Maps Distance Matrix API. This article is going to be a learning with fun or you can say download some fun [...]

get Data Type of Variable in VBA – VarType() VBA function

Dear Friends, Some time during the VBA programming you may need to perform different action based on "what is the type of the variable" you are dealing with. Or in other words what kind of data is stored in a variable. In VBA, if you have not defined type of a variable while declaring it using "Dim statement", then whatever [...]

Page 1 of 612345...Last »