Vishwamitra Mishra - About me

Welcome to vmlogger.com

Thanks for visiting this website. This blog is meant for sharing knowledge about Microsoft Excel, especially VBA (Macro) – Visual Basic for Applications.
Always open to receiving feedback about my articles… there is always a possibility of improvement !!

Hope you will enjoy reading this blog and get benefits.

About this blog

Story – How it all started

I was working as a Software Test engineer in one of the leading Indian IT firms in Bangalore. I started my career as a Manual Tester. And not liking manual testing was no exception. The first project that I was involved in had to deal with lots of Management and Project data handling resulting in lots of Excel sheets and numerous trackers. Back in 2007, I was not even introduced to “Excel Macros” or “Excel VBA”.

To be honest, I used to get surprised seeing the automated stuff in excels with a click of buttons. My assumption was that these were Microsoft customizations available. Out of my curiosity, I asked one of my senior and he showed me the code behind those buttons. That was my first interaction with VBA.

That was another surprise… Oh my god, behind those excels sheets there was another place where you can write so many lines of code? I was amazed and started going through those existing “trackers” in my project and codes behind them. Took help from Microsoft Excel help and Google. In no time I was so fascinated and developed so much of interest that I used to wait for my office hours to get over so that I could start reading more and more about macros. And in no time I built my first macro.

As time progressed I had built many useful tools in excel for my project and my learning and creativity curve rose since then 
A fine day it occurred to me to start a blog and publish these small pieces of codes and tools that I had and which might also help others users, especially beginners like me. I, then, created a blog on Google’s Blogspot.com.

Later that year, I registered a domain with the name which came first into my mind “LearnExcelMacro.com”. This is how this domain was born. I initially started posting code snippets, tips and tricks related to Excel and Excel VBA.
And today, you can find numerous helpful tools, articles, videos, VBA book for beginners.

.

Subscribers

Articles

Downloads

Tools & Templates

Expectation

What can you expect here?

I try to keep my articles in a very simple language and “To the point”. Most of the articles will have necessary images, diagrams, code snippets and sample Excel files to download.

Every article, tool and template available here is based on my research as a user when I started as a beginner. So, I hope you will have a good experience reading my articles and using freely available tools and templates.

But as they say, there is always a room for improvement. So your feedback is always welcome and appreciated.

Z

250+ Articles [Posts]

More than 250 articles related to excel VBA.

Z

Exercise File to Download

Most of the articles, has a downloadable file for you to practise that particular topic

Z

Code Snippets, Images, diagrams etc.

Each post has necessary code snippets, diagrams and screenshots. 

Z

20+ Free Tools/templates

There are more than 20+ tools and templates available to download for free.

Recommended Pages

Recommended Tutorials

.

Automate sending email via Excel VBA

Enjoy several tutorials and articles for sending email via Excel VBA. You can be able to download some amazing tools as well for sending emails.

User Defined Functions in Excel

Didn't find a formula which you wish to have in Excel? Don't worry, create your own formula to use it in your excel sheets.

Excel VBA tutorial for Intermediate

Some amazing tutorials for intermediate level excel vba learners.

FREE Downloads

Download some amazing tools and templates in order to improve your productivity at work.

Beginner's Page

Excel macro tutorials for beginners. Learn basics to start with your excel vba journey.

HP Quality Center - VBA Codes

Download and read so many amazing piece of vba codes in order to automation HP QC related tasks, reporting etc.

VBA Programming

Learn programming concepts related to Excel VBA with sample code and illustrative images. You will learn here about For Loop, While loop, Do While loop, If else, Switch, etc.

Databases - via Excel VBA

Want to connect to a Database via Excel VBA Code? Run any kind of query like Select, Update, Delete, Insert via Excel VBA? This series of articles will explain you in a very detailed manner.

Join Today & GET a FREE e-Boook!

With over 50,000+ readers and counting Join NOW and get a FREE E-book to download !!

Expectation

How do I help you learn?

Z

VBA Code snippets

Useful VBA code snippets readily available to copy paste and run

Z

Beginner, Medium, Advance

Excel VBA tutorials for all readers. Beginner, intermediate and advance.

Z

Categorized Tutorials

Tutorials are categorized based on specific topics such as dealing with files, sending email etc.

Z

FREE Tools and templates

Useful Excel Tools (FREE Download) developed using Excel VBA

Z

VBA Functions & Formulas

Important excel Formulas and VBA functions

Z

Tips & Tricks

Day to day useful tips and trick

Helping hand

People who help me running this site

My partner in crime… Shagun, she supports me in all way to do this

Non Technical Reviewer

Review and editing of all non-technical contents on the site. Because my writing skill sucks 😉

Support

Allow me to spend some time at home doing this activity apart from my 9 to 5 full time job. I thank her for that

Designer

Help me in designing the new layout, look & feel of this blog.

Pin It on Pinterest