Excel Macro Tutorial Archives

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

[fusion_text]ear 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,...

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

Excel Macro, Excel Macro Tutorial

ext files are one of the simplest, lightest file types. This is the reason it is highly used in programming to store a lot of configuration-related data, logs and so many other necessary data...

Calculate distance between two places in Excel [With Fun]

Excel Macro, Excel Macro Tutorial, Interesting VBA Functions, Popular Articles

Dear readers, Last week, I had placed an article on how to create a 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...

VBA to Add Static Google Map in Excel Sheet

Excel Macro, Excel Macro Tutorial

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

Windows FileDialog to Select File or Folder Path in VBA

Excel Macro, Excel Macro Beginner, Excel Macro Tutorial, Excel Tips

Dear friends, In my many Excel Tools, wherever there is a need for a 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 the windows file explorer window. It is the same window that you might have...

How to create folders in windows via Excel VBA

Excel Macro, Excel Macro Beginner, Excel Macro Tutorial

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]

Excel Macro, Excel Macro Tutorial

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

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

Excel Formula, Excel Macro Tutorial, Excel Tips

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

[YouTube Video] Complete Guide to Write your First Excel Macro

Excel Macro Beginner, Excel Macro Tutorial, Video Tutorial

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

[VIDEO] Excel Macro Tutorial-Part-1-Introduction to Excel VBA

Excel Macro Beginner, Excel Macro Tutorial, Video Tutorial

Dear Readers, Recently, I realized that Videos/audios are sometimes more easy medium for a blogger like me who is mainly teaching some new things in Microsoft Excel area, to convey the message in a very appropriate way. At the same time, for a reader as well it is...

Download FREE Tools and Templates

There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.

Hurray..Lets Go

What is Excel Formula?

Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).

Know more