Post Description

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

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

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.

Language : English
Paperback : 60 pages [ 235mm x 191mm ]
Release Date : October 2012
ISBN : 1849688443
ISBN 13 : 9781849688444
Author(s) : Robert Martin