Yearly Archives: 2014

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

Interacting with Powerpoint Slides – Tutorial – Part 1

Brief about the Tutorial In this tutorial, I am planning to write 3-4 articles which will be all around Microsoft Power Point Presentation but using Excel Macro. So as part of this tutorial you will basically learn how to Open, Close, save, Copy a slide from one Presentation to other, deleting a slide, modifying the content of the slide and [...]

Excel VBA – Few little help in your 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 using 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 [...]

Query Database and Spreading the Records in Excel – VBA Code

In continuation to one of my article which shares the connection strings to connect to different data bases. In this article I explained and shared every possible VBA code to make connection with many databases like Oracle, SQL etc. but does the Story ends there?? NO WAY !! That's the starting point. You are going to make connection to Database [...]

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 article before jumping up to this article. Click on [...]

Excel Tip : How to Make an Excel Cell secured for Password

One of my friend wanted me to write an article on How can a person achieve making an Excel Cell behave like a password text box which is masked and secured. I have tried to achieve that up to some extent but not 100%. Go through with this article and provide your feedback or suggestion regarding this topic !!. You [...]

Page 1 of 3123