vishwamitra

About Vishwamitra Mishra

My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor’s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.
Thanks for visiting my blog.

Excel VBA Tips: How to comment or uncomment a Block of Code in VBA

Comment the codes Dear Friends, Providing proper short descriptions for each of your functions or statements etc. makes your VBA code - easy to read, easy to understand by anyone who refers your code. Now the question is, how can you write description in English language in between your VBA code? VBA compiler will start giving compile error. [...]

Excel VBA Basics : All about Debugging Excel VBA code

Dear All, Debugging VBA Code In Tutorial section for Beginners, I have written many basic articles like WHAT IS EXCEL MACRO, HOW TO WRITE IT, WHERE TO WRITE IT etc. As you know Errors are common while writing your code in VBA or in any other programming language for that matter. This is not a problem. As long [...]

Complete VBA tutorial to interact with Power point Presentations – Part – 2 of 2

This is a continuation of my previous article about Interaction with Power point Slides using Excel Macro. In my previous article we learn how to create a New Power Point Presentation using Excel Macro (by creating Power Point Object). Bit of a Story about this Article: This article I planned to write due an incident took place at my work. [...]

Register Yourself for FREE Session on “Basics of Excel VBA”

Dear Readers,   LearnExcelMacro.com is going to conduct a FREE online session on "Basics of Excel VBA". This session is going to be conducted on Google-Hangout hence to receive an invite for this FREE session you need to register yourself by submitting the below form. If below form is not visible properly, kindly click on below link to register yourself [...]

Wishing you and your Family a Very Happy Diwali

Wishing you a very Happy Diwali to you and your family. May this Diwali brings health, wealth and prosperity in your life. May this festival of Lights brings light in each one of your life For my readers who does not know about this festival: This an Indian Festival called as "Festival of Lights". It is also known as "DEEPAVALI". [...]

By |Categories: Personal|Tags: , |0 Comments

Complete VBA tutorial to interact with Power point Presentations – Part – 1

D ear Friends, First of all, I apologize for not responding to many of your questions around dealing with PowerPoint presentations through Excel Macro. Many of you have sent me so many questions around this topic. Questions, which were, mostly, asked were like - Sample List of Questions...   VBA code to create a presentation slide based on a [...]

Excel VBA Tips – Two excel VBA Tricks to help in day-to-day Coding

Dear Readers,   In this article I am going to share with you - Two little VBA code which will help you in your day-to-day coding life. 1. How to disable Copying Objects with cells through VBA When you are trying to move or copy a Sheet or set of Sheets in to another workbook then by default it copies [...]

CELLS() and RANGE() – Are they same? Are they Excel VBA Object?

Dear Friends, Many of you who are interested in excel Macro or if you have ever tried to read and understand a VBA code, you would have seen two ways of referring a cell in Excel Macro: Using Range() To refer value of Cell D4, you can use Range("B4").Value. To know more about RANGE() you can read my previous article [...]

Excel Macro Beginners – What is Range Object in Excel VBA

Dear readers, Before we discuss the Range Object technically, let us see what is RANGE in excel? In a very simple manner if I define Range, I can say that RANGE is a collections of cells which are in a sequence. This collection can have one or more than one cell. As I have defined, Range is a collection of [...]

Different ways of Reading RecordSet Object in Excel Macro

Dear Friends, In my previous article, I emphasized mainly on how to execute different kind of queries in database using Excel VBA. I covered one example How to display or spread a RecordSet in excel Sheet. But in this article I am going to focus on different ways of reading RecordSet Object. How to get Column Names from your recordSet [...]

Page 5 of 20« First...34567...1020...Last »