Profile

Cover photo
Excel VBA Tutorial
Works at Infosys
Attended Devi Ahilya Vishwavidyalaya
Lives in Amsterdam netherlands
197 followers|185,286 views
AboutPostsYouTube+1's
Story
Tagline
Blogger, Excel Lover, VBA developer, Software Test Analyst
Introduction
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 :)
Education
  • Devi Ahilya Vishwavidyalaya
    Computer Science, 2004 - 2007
    Bachelor's in Computer Science
Basic Information
Gender
Male
Other names
Vishwa
Work
Occupation
Software Test Analyst
Skills
Testing, Automation, VBA coding,
Employment
  • Infosys
    Software Test Analyst, 2007 - present
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Amsterdam netherlands
Previously
Bangalore India - Monterrey Mexico - Indore India
Links
Other profiles
Contributor to

Stream

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
1
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.
1
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.
1
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
1
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.
1
Add a comment...

Excel VBA Tutorial

Shared publicly  - 
 
1
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
1
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
1
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
1
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...
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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...
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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...
www.learnexcelmacro.com

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 ...
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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...
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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
www.learnexcelmacro.com

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