Excel Programming with VBA Starter

Get started with programming in Excel using Visual Basic for Applications (VBA) with this book and ebook.

Excel Programming with VBA Starter

Progressing
Robert Martin

Get started with programming in Excel using Visual Basic for Applications (VBA) with this book and ebook.
$9.99
RRP $9.99
eBook

Instantly access this course right now and get the skills you need in 2016

With unlimited access to a constantly growing library of over 3,500 courses, a subscription to Mapt gives you everything you need to get that next promotion or to land that dream job. Cancel anytime.

+ Collection
Free Sample

Book Details

ISBN 139781849688444
Paperback60 pages

Book Description

Do you have repetitive tasks that you would like to get rid of for good? Would you like to integrate Office Applications in order to streamline some of your tasks? Then look no further. This compact book will provide you with the knowledge to get your VBA programming off the ground and up to a comfortable cruising speed.

"Excel Programming with VBA Starter" was born out of the need to have a short, but yet all-encompassing book that would give you a solid foundation in programming with Visual Basic for Applications. This book will enable you to harness the power of VBA in Excel and put it to good use throughout the course of your working day.

Can't find properties and methods of an object? Don't know what a property, method or object is? Covering simple and advanced topics, create powerful, reusable examples such as IO, picking files from within Excel and automatically attaching them to e-mails. Learn and use the concept of encapsulation to condense code into bite-size methods to be easily accessed from within your projects, plus much more.

Table of Contents

Chapter 1: Excel Programming with VBA Starter
So, what is VBA?
Recording a macro, adding modules, browsing objects, and variables
Quick start – VBA programming
Top features you'll want to know about
People and places you should get to know

What You Will Learn

  • Get started with recording and play macros
  • Learn to use sub routines, with and without arguments
  • Create user-defined functions (UDFs)
  • Work with loops and effectively debug your code
  • Use UDFs to describe arguments, create custom categories and more
  • Reference external libraries and use them in your project
  • Program interaction and sharing with other Office Applications
  • Learn to work with enumeration
  • Use advanced features and work with Windows APIs
  • Create classes and hide away complex code

Authors

Table of Contents

Chapter 1: Excel Programming with VBA Starter
So, what is VBA?
Recording a macro, adding modules, browsing objects, and variables
Quick start – VBA programming
Top features you'll want to know about
People and places you should get to know

Book Details

ISBN 139781849688444
Paperback60 pages
Read More

Read More Reviews

Recommended for You

Windows Phone 7.5 Application Development with F#
$ 14.99
Instant Windows 8 C++ Application Development How-to
$ 12.99
Microsoft Windows Intune 2.0: Quickstart Administration
$ 29.99