Cover photo
Excel VBA Tutorial
Works at Infosys
Attended Devi Ahilya Vishwavidyalaya
Lives in Amsterdam netherlands
197 followers|185,286 views
Blogger, Excel Lover, VBA developer, Software Test Analyst
Vishwamitra Mishra is full time Software test lead in Amsterdam. You can find me:

Mail me
Facebook Page
My Blog
Bragging rights
Married with my best friend, my love.. Shagun Sharma :)
  • Devi Ahilya Vishwavidyalaya
    Computer Science, 2004 - 2007
    Bachelor's in Computer Science
Basic Information
Other names
Software Test Analyst
Testing, Automation, VBA coding,
  • Infosys
    Software Test Analyst, 2007 - present
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Amsterdam netherlands
Bangalore India - Monterrey Mexico - Indore India
Other profiles
Contributor to


Excel VBA Tutorial

Shared publicly  - 
How to get help in excel when you do not have internet #noInternet #excel #excetips #offlineHelp
Get Microsoft offline help within your workbook. How to get offline help in Excel 2013. Download excel 2013 offline help. How to read offline VBA help in Excel
Add a comment...

Excel VBA Tutorial

Shared publicly  - 
VBA to Add Static Google Map in Excel Sheet
Generate Google Static map in your excel sheet dynamically. VBA code to generate map using google map API. Download Google map generator Excel for your City.
Add a comment...

Excel VBA Tutorial

Shared publicly  - 
[VIDEO] Excel VBA Tip – Hide Horizontal scroll bar in Excel
Get regular update on very interesting and new Excel VBA Tips. How to hide horizontal and vertical scroll bar using excel macro. Show/hide grid lines, show/hide headings etc.
Add a comment...

Excel VBA Tutorial

Shared publicly  - 
How to create folders in windows via Excel VBA 
Create folders and sub folders using excel VBA code. How to Check if folder path already exists. Create a folder inside a directory using Excel Macro. Macro to create a folder
Add a comment...

Excel VBA Tutorial

Shared publicly  - 
Excel Tool : Folder Structure Creator - FREE DOWNLOAD 
Folder Structure Creator - A FREE Excel VBA Tool. Download this folder structure creator tool. VBA code to create hierarchical folder structure in windows.
Add a comment...

Excel VBA Tutorial

Shared publicly  - 
Add a comment...

Excel VBA Tutorial

Shared publicly  - 
VBA button to select File or Folder path using Windows FileDialog
Code to launch windows file dialog the select the file path. Select the folder path by using windows file explorer dialog. how to assign macro to an image. How to make nice buttons in excel
Add a comment...

Excel VBA Tutorial

Shared publicly  - 
Send Image of a Range from Excel embedded in Mail [Inline Image in Mail]
Macro to send image of a range embedded in Outlook body email. Send image of a range embedded in the outlook email using excel Macro. How to send embedded image in Outlook mail body using excel vba
Add a comment...

Excel VBA Tutorial

Shared publicly  - 
List all Folders and Sub-folders in Hierarchical Structure [FREE DOWNLOAD]
Download free excel tool to list all the folders and sub folders in excel. How to list folders and sub-folders in excel using excel vba. Macro to list folders and sub-folders
Add a comment...
Excel VBA Tutorial's +1's are the things they like, agree with, or want to recommend.
[YouTube Video] Excel macro Tutorial - Part -1- An Introduction to Excel...

Excel Macro tutorial for beginners level - part 1. What is Excel VBA and what difference between excel VBA and Excel macro 4.0. History of E

Wish you Merry Christmas & happy Holidays

An Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet to wish you Merry Christmas and Happy Holidays. Enjoy and h

Learn Excel Macro Excel Macro Beginners - What is Range Object in Excel VBA

A complete Overview of Range Object in Excel Macro. This a tutorial of excel beginners which explains each and every aspects of Range Object

Learn Excel Macro Different ways of Reading RecordSet Object in Excel Macro

For DBCol = 0 To RecordSetObject.Fields.Count - 1 Worksheets("Data").Cells(xlRow, xlCol).Value = RecordSetObject(DBCol).Name xlCol = xlCol +

Learn Excel Macro Query Database and Spreading the Records in Excel - VB...

Excel Macro to execute an INSERT, UPDATE, DELETE Statement in DB. Queries which does not return any record after running, can be executed by

Learn Excel Macro How to refer Values from a Named Range - Excel VBA

I am writing this new article about , How can you read values stored in a Name range in Excel Sheet using Excel VBA. See Excel Macro to read

Learn Excel Macro Excel Tip : How to Make an Excel Cell secured for Pass...

An Easy way to make your excel cell behave like a Password TextBox where your password is masked and no one can see or copy your entered pas

Learn Excel Macro Excel Macro : Excel VBA code to Protect and UnProtect ...

Hello Friends,. This is a small VBA code to help you in dealing with Protecting and UnProtecting the WorkSheet using Excel Macro. Assuming t

Learn Excel Macro Excel Macro : Excel VBA code to Print the Sheet

YourObj (Required): It is a variable which represents your Object which you want to print. For example: Workbook, Worksheet, Chart etc. From

Learn Excel Macro How to Send an Email using Excel Macro from Gmail or Y...

Dear Readers,. In this article we are going to learn how to send an email automatically by Excel Excel VBA. While executing the Excel Macro

Learn Excel Macro Excel Macro Tutorial : Excel Form

Dear Beginner,. In this article I am going to explain every aspects of VBA Form. User forms in Excel is really nice to see. It looks very fa

Learn Excel Macro VBA String Functions - INSTR() Function

This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString i

Learn Excel Macro Excel Trick - Sheet Protection - Protect it and Stay Free

Dear Readers,. I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To

Learn Excel Macro Excel OFFSET Function - Excel Tutorial

Dear Friends,. What is OFFSET () Function? OFFSET() is a built-in function in excel which returns a range reference which is offset a number

Learn Excel Macro Spreading data across Columns in Excel Without VBA Code

In my previous article as you learnt how to split data using VBA SPLIT() function. In this Article I am going to explain you how to separate

Learn Excel Macro

Dear Readers,. My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor's Degree in Computer Science from D.A.V.V. Indore &

Learn Excel Macro

Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. Let's learn and to know the mos

Learn Excel Macro Excel Trick - SMART Method to make White Background

How do we do this formatting GENERALLY? Generally we follow the below steps to achieve this formatting: Step 1. Select the whole sheet by cl

Learn Excel Macro How to create User Defined Function in Excel

Dear Readers, User Defined functions (UDF) is also known as Custom Functions (formulas) in Excel. Previously I have created many different U

Learn Excel Macro Custom Formula to Reverse a String in Excel

Dear Friends, This is a very small but useful Custom Function which can be used to reverse a string in excel. In VBA (Excel Macro) there is