Home » Excel VBA Book

Preface

Submitted by ravisagar on Sat, 07/05/2008 - 14:31.
Overview

I have been using Microsoft Excel for so many years and despite being a Microsoft product I like it so much. Excel is one of the most powerful application I have ever seen and worked. It is fast and it offers plenty of features. It also supports VBA Programming for Automating many things, which in fact is one of the most powerful feature of Microsoft Excel. This book is based on Real Life examples which I had faced in my life. This book is a continuous process, and I will continue to improve it and add more examples.

If you have any suggestions on how to improve this book then do let me know using the contact form. http://www.autogrid.info/contact
 
The Audience for this book
 
This book is for all those people who want to "excel in excel" with the help of VBA Programming. This is not a book on Microsoft Excel, rather this is a book on VBA Programming. In this book you will find information related to the various aspects of VBA in Excel.
 
This book will teach you how to create Macros in Excel to automate daily tasks and avoid repetitive work. Professional with the following roles may find this book useful:
 
- Financial Analyst
- HR Professionals
- Charted Accountants
- Quality Assurance
- Data Processing
- MIS
- Office Coordinators
 
Organization of the book
 
This book first talks about the overview of VBA Programming. Before starting any Programming in VBA one should get a brief idea about the VBA Editor, which basically is the IDE (Integrated Development Environment) where Macro Coding is written. As you progress to the later chapters of the book you will find more information about the Programming constructs used in the VBA Programming. Programming constructs are the building blocks of any Programming Language. Middle Chapters will talk about the Expressions and the Control Statement. In the last chapters you will find some information on the Error Handling and Database connectivity.
 
Real Life Examples
 
The motive behind writing this book was to make people some hands on knowledge of VBA Programming. This book doesn't have any great theoretical concepts and this book doesn't even have a good reference of VBA Programming. This book will give you enough basic knowledge of VBA Programming Language and you can then start writing more and more Macros. Though each chapter will have some Code Snippet to make you understand about the topic but in the end of this book there are plenty of Real Life examples which I have faced during my years of exploring VBA Progamming. Implementing Real Life Problems will not only give you confidence to work on VBA Programming but also you can relate to the problems which you must have faced.
 
Background Information
 
No prerequisites are required, but it would be good if you have some prior knowledge of Programming. I expect that you have at least a decent working knowledge of Excel. You should know at least these things - How to Create/Edit an Excel Worksheet - How to work with common Formulas like sum, average, etc
 
How to contact Us
 
I have taken lot of care in writing this book but if you find any information that is wrong or if you find any Typo then people contact me using contact form. http://www.autogrid.info/contact
 
About the Author
 
Ravi Sagar did his Engineering in Information Technology from Guru Gobind Singh Indraprastha Technology in 2003. Currently working in a Telecom company in Delhi NCR region, he has been writing Macros in Excel since 2003. Ravi is also a Technical Consultant and Trainer on Office Automation using Excel VBA Programming. His other interests include Open Source technology and he loves the Linux Operating System.
 
To contact Ravi please check his website http://www.ravisagar.in
 
This book would not have been written without the precious help my friends Vinod Kumar and Nizam Mohammad. Their continuous and extended support in Proof Reading this book was beyond words. They tested each and every example mentioned in this book, which made me confident that this book will have the minimum errors.
 
I would also like to thank my Family for encouraging me to write this book.
 
-Ravi Sagar July, 2008

 

‹ Excel VBA Programming Book (with real life examples) - Ravi SagarupWhat is VBA Programming ›