Excel Programming with VBA Starter [Instant]


This title is available as an eBook only
Excel Programming with VBA Starter [Instant]
eBook: $9.99
Formats: PDF, PacktLib, ePub and Mobi formats
$8.50
save 15%!
Print & eBook also available on:
Learn in an Instant - Short, Fast, Focused
Overview
Table of Contents
Author
Support
Sample Chapters
  • Learn something new in an Instant! A short, fast, focused guide delivering immediate results.
  • Extend and enhance your Excel spreadsheets using the power of Macros and VBA programming
  • Get to grips with the VBA language to create professional spreadsheets
  • Follow practical examples to common problems that you will find yourself using time and time again

Book Details

Language : English
eBook : 60 pages
Release Date : October 2012
ISBN : 1849688443
ISBN 13 : 9781849688444
Author(s) : Robert Martin
Topics and Technologies : All Books, Other, Enterprise, Microsoft
Sorry, the table of contents for this book is not yet available.

Robert Martin

Robert Martin is an Excel MVP and Microsoft Certified Professional. With a background in finance, his career has ranged from being an IT Director of an investment bank in London to doing charity work in Africa, before moving to Brazil in 2007 and setting up an IT consultancy firm and then authoring training (audiovisual and written) material on Microsoft technologies.

Currently he works in Brazil as an IT Consultant.

Robert Martin has also authored the following books:

  • Excel Avançado, Digerati 2008 RibbonX
  • Customizing the Office 2007 Ribbon, Wiley 2008 Excel e VBA na Modelagem Financeira
  • Uma abordagem prática. Axcel Books, 2005
Sorry, we don't have any reviews for this title yet.

Code Downloads

Download the code and support files for this book.


Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sorry, there are currently no downloads available for this title.

Frequently bought together

Excel Programming with VBA Starter [Instant] +    Microsoft Dynamics GP 2013 Reporting - Second Edition =
50% Off
the second eBook
Price for both: $35.60

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • 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

In Detail

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.

Approach

Get to grips with a new technology, understand what it is and what it can do for you, and then get to work with the most important features and tasks. This is a starter guide, covering the basics you need to get up and running as quickly as possible.

Who this book is for

This book is written for users of Excel who want to speed up and streamline normally arduous tasks for maximum productivity.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software