E-book details

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

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

Robert Martin, Robert F Martin

Ebook
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.
  • Excel Programming with VBA Starter
    • Table of Contents
    • Excel Programming with VBA Starter
    • Credits
    • www.PacktPub.com
      • Support files, eBooks, discount offers and more
    • www.PacktLib.PacktPub.com
      • Why Subscribe?
      • Free Access for Packt account holders
    • Excel Programming with VBA Starter
      • So, what is VBA?
        • The basic features of VBA
        • What kind of things can you do with it?
        • How can you use this technology within your existing projects?
      • Recording a macro, adding modules, browsing objects, and variables
        • Recording a macro
          • Option 1 Recording a macro from the status bar
          • Option 2 Recording from the Developer tab
        • Executing your code
        • Saving a workbook containing macros
        • Adding a module
        • Browsing objects
        • Working with variables
        • The Immediate window
        • And thats it
      • Quick start VBA programming
        • Working with loops
          • Method 1 For-Next loops
          • Method 2 For Each-Next Loops
          • Method 3 Do-While and Do-Until loops
        • Dimensioning and instantiating objects
        • Subroutines and user-defined functions
          • Subroutines
          • Functions
      • Top features you'll want to know about
        • Enumeration
        • Classes
        • External libraries
      • People and places you should get to know
        • Official sites
        • Resources
        • Articles and tutorials
        • Community
        • Blogs
        • Twitter
    • About the author
    • About the reviewers
    • Index
  • Title: Excel Programming with VBA Starter. Get started with programming in Excel using Visual Basic for Applications (VBA) with this book and
  • Author: Robert Martin, Robert F Martin
  • Original title: Excel Programming with VBA Starter. Get started with programming in Excel using Visual Basic for Applications (VBA) with this book and ebook.
  • ISBN: 9781849688451, 9781849688451
  • Date of issue: 2012-10-18
  • Format: Ebook
  • Item ID: e_2wku
  • Publisher: Packt Publishing