Early and Late Binding is a common phenomenon across computer programming languages. In simple terms, Binding means - how and when methods or properties of an Object are compiled and checked. In the case of Excel VBA [COM - Component Object Model] - this occurs when...
Results for "list"
Regular Expression and its usage in Excel VBA
Dear Reders, In this article, I am going to teach you What is Regular Expression (RegExp or RegEx)? and how RegEx is used in Excel VBA programming. You will also learn the usage of Regular Expressions in Excel VBA with some example VBA code. You can also find some...
Do you want to be part of my Next article?? … Here you go…
Dear Readers, In my next article, which will be published next Monday, I am going to cover following two topics: 5 Interesting but rarely used features/functions in Excel/Excel VBA 5 Interesting facts about Excel [from history...] Before I publish these articles, I...
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. Did you know? CSV is an abbreviation of Comma Separated Value. As the name suggests, it is clear that this file stores the tabular...
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
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...
FREE Download : Send Multiple Emails Tool – Ver 4.0
Dear LEM Readers, Here I come with a new version of Send multiple Email using Excel. Are you planning to send all of your friends a Happy New Year Email for this coming new year 2017? Sounds good !! but would you put every one's email in to List and send them all a...
Calculate distance between two places in Excel [With Fun]
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...
Excel Tool : Folder Structure Creator
Dear readers, In my previous article I posted an article about how to create folder in windows by Excel VBA code. That triggers me to build an Excel tool to create a hierarchical or Tree folder structure in any directory which is defined by you in excel sheet. Before...
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,
Buy a coffee for the author
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.
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 (=).
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...
Send Multiple Emails Tool – Ver 4.0 [Imp Bug fixes]
Dear friends, The version of Send Multiple Emails Tool, I released last, there was a small issue with the mail sent by...
FREE Download : Send Multiple Emails Tool – Ver 4.0
Dear LEM Readers, Here I come with a new version of Send multiple Email using Excel. Are you planning to send all of...