Dear friends, The version of Send Multiple Emails Tool, I released last, there was a small issue with the mail sent by outlook. Thanks to you all for providing me the prompt feedback about the same. I have fixed it but I have not changed the version of the tool as...
Results for "tool"
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...
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...
FREE Download : Send Multiple Email Tool – Ver 3.0
First of all, I would like to thank you all for appreciating and giving the feedback about Send Multiple Email - VBA Tool. I have come up with the next version of the same tool based on your suggestions and feedback. I promise this version is going to amaze you with...
How to connect to Access Database – ADO Connection String
Using Excel Macros (VBA) you can connect to any Databases like SQL, Oracle or Access DB. In this Article you will learn, how you can do a connection with an Access Database. Access Database connection string is different for Access 2003 (*.mdb) and Access 2007/2010...
Implicit and Explicit declaration of variables in VBA
Hello friends, In the Article related to variables in VBA, I had explained following things: 1. What is Variable ? 2. Importance of Variable in Excel Programming 3. Important Rules of Variables, you must know, before declaring a Variable 4. Different Types of...
Excel Macro Tutorial : What is Excel Macro ?
Dear Beginner, In this Excel Macros Tutorial, you are going to learn the Basics of Excel Macro. This is the first Article of this Tutorial so Let's begin with What is Excel Macro What is Excel Macro ? Let's not get too much in detail at this point. For now, in simple...
How to refer Values from a Named Range – Excel VBA
Dear Readers, I am writing this new article about How can you read values stored in a Name range in Excel Sheet in Excel Macro . For the readers who are unaware or need more information about the Name Range, I would suggest you to first go through the below mentioned...
How to Get Excel version using VBA Code
Dear Friends, Usually while working on any of the VBA projects, it becomes important for me to first check the version of excel which user is using and based on that certain functionality of my tool may or may not work. For Example: If you have some sales data using...
Calculate MOD of Large Numbers in Excel
Excel Trick to Calculate MOD of Big Numbers. This article is all about MOD function in Excel. Every aspect of the MOD function is covered here in this article. At the end of this article, I have also explained a VBA code to calculate the MOD of large numbers. I have...
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 (=).
VBA: Reverse a string
It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality....
Data Anonymizer: Open Source to Anonymize Personal Data
In the ever-evolving landscape of software development, safeguarding personal data is paramount. Whether you're a...
Custom Excel Formula to Count based on Color
Dear Readers, Last Friday, my wife, Shagun Sharma, who is a Vlogger shared an excel sheet with some data and a problem...