Excel Programming with VBA Starter

by Robert Martin

Overview

Excel Programming with VBA Starter is the perfect companion for those beginning VBA or who have little experience but need to develop their knowledge fast and simply. Example-driven, easy to relate to with common objectives you will no doubt come in contact with daily. This small yet wide-ranging book will take you from zero to hero in no time.

Excel Programming with VBA Starter goes from the beginning, starting with recording and playback of macros, to the more advanced, covering topics such as enumeration and classes. Whist you read you will also develop a number of useful examples ready for use in your very own projects.

Can't find the properties and methods of an object? Don't know what a property, method or object actually is? In quick and simple language learn not only what they are but how to use them to the max. Learn while doing, covering complex topics while creating reusable examples such as IO, picking files from within Excel and automatically attaching to e-mails for sending. Learn and use the concept of encapsulation to condense code into bite size methods that can be easily accessed and used from within your project and much more.

From Zero to Hero in no time, follow and recreate examples to establish a solid background in the most commonly used and important features of VBA that it has taken others many years to master getting yourself ready to take the leap into more complex and specialized topics.

Product Details

ISBN-13:	9781849688444
Publisher:	Packt Publishing
Publication date:	10/22/2012
Pages:	62
Product dimensions:	7.50(w) x 9.25(h) x 0.13(d)

About the Author

Robert Martin is an Excel MVP and Microsoft Certified Professional. With a background in finance, he has worked as an IT director for an investment bank in the UK, and worked on charitable projects in Africa before turning to authoring on MS Office development. Currently he works in Brazil as an IT Consultant.