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.

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

Send Image of a Range from Excel embedded in Mail [Inline Image in Mail]

Dear Friends, Couple of my friends asked me about this like how can I send screenshot of a particular range area of my excel sheet embedded in my HTML mail with other texts in my email. I also got this question on Microsoft Excel forum where I answered that question by providing a piece of code. Though there were some [...]

[VIDEO] Excel VBA Tip – Hide Horizontal scroll bar in Excel

Dear Readers, Every week, I am going to publish at least one Excel VBA Tip where I will be sharing some small code snippets, tips, tricks which will be useful for you during development of any Excel VBA tool. YouTube Channel You can subscribe to LearnExcelMacro.com Channel where all the videos are going to be uploaded. You will be notified [...]

[VIDEO] Excel Macro Tutorial-Part-2- Your first VBA Program

Dear Readers, Here is the second episode of the Excel Macro Tutorial for Beginners. If you have not watched the first part of the Tutorial, you can watch it here or on the YouTube Channel. Kindly provide your feedback on this video. Any improvements/ suggestions are always welcome. You can provide your feedback by typing comments in this article or [...]

Page 1 of 712345...Last »