Excel Programming with VBA Starter

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

Excel Programming with VBA Starter

Robert Martin

Get started with programming in Excel using Visual Basic for Applications (VBA) with this book and ebook.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$7.00
RRP $9.99
Save 29%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$7.00
$29.99p/m after trial
RRP $9.99
Subscription
eBook
Start 30 Day Trial

Frequently bought together


Excel Programming with VBA Starter Book Cover
Excel Programming with VBA Starter
$ 9.99
$ 7.00
Data Analysis and Business Modeling with Excel 2013 Book Cover
Data Analysis and Business Modeling with Excel 2013
$ 31.99
$ 22.40
Buy 2 for $24.50
Save $17.48
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

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

Managing Windows Servers with Chef Book Cover
Managing Windows Servers with Chef
$ 13.99
$ 9.80
Practical Data Analysis Book Cover
Practical Data Analysis
$ 29.99
$ 21.00
Linux Shell Scripting Cookbook, Second Edition Book Cover
Linux Shell Scripting Cookbook, Second Edition
$ 26.99
$ 5.40
Expert Python Programming Book Cover
Expert Python Programming
$ 26.99
$ 5.40
Responsive Web Design with HTML5 and CSS3 Book Cover
Responsive Web Design with HTML5 and CSS3
$ 23.99
$ 4.80
Zen Cart: E-commerce Application Development Book Cover
Zen Cart: E-commerce Application Development
$ 29.99
$ 21.00