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.

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

VBA to Add Static Google Map in Excel Sheet

Dear Readers, In this article, I am going to give you a quick tip - how can you add google map in your excel workbook without opening the google map in any browser. More details about this will follow... To do that I am using Google Static Map API. I am not going explain you more about this API here [...]

Windows FileDialog to Select File or Folder Path in VBA

Dear friends, In my many of the Excel Tools, wherever there is a need of file path to be entered from your local PC, I try to put a browse button to locate that file in your Windows PC through windows file explorer window. It is the same window which you might have seen in windows for selecting a file. [...]

How to create folders in windows via Excel VBA

Dear LEM Readers, Till now, I had published many articles on how to list files from a folder / sub folder,

List all Folders and Sub-folders in Hierarchical Structure [FREE DOWNLOAD]

Dear Readers, Many of you were looking for a excel tool same as File Manager - which lists down all the files from each and every folders and subfolders, to list down all the folders and sub-folders under a given Main Folder Path. Therefore rather than replying to you all individually a piece of code, I though of posting an [...]

Page 1 of 612345...Last »