Master Visually Excel 2003 VBA Programming

By Julia Kelly

Book Overview

* More than 400 task-oriented pages show intermediate-to-advanced users how to automate, customize, and integrate Excel using Visual Basic for Applications and VBA-based macros * Crisp, two-color screen shots and succinct step-by-step instructions demonstrate how to create macros, add customized features to spreadsheets, and build powerful Excel-based applications * Shows how to make macros "smart," create and customize VBA code, program Smart Documents, make Excel communicate efficiently with other applications, and more * With VBA, users can buy Excel off the shelf and customize it to meet their specific business needs instead of building applications from scratch-saving users and businesses time and money * All information is applicable to Excel versions 2000, 2002, and 2003

• Format: Paperback
• Language: English
• ISBN: 0764579738
• ISBN13: 9780764579738
• Release Date: February 2005
• Publisher: Visual
• Length: 407 Pages
• Weight: 2.05 lbs.
• Dimensions: 1.0" x 8.3" x 11.2"

Customer Reviews

Great Book

This is a perfect book for both beginning and intermediate users of VBA. I have about 15 VBA books(I've been trying to teach myself)and this is one of the top three. Tons of examples that are very easy to understand and copy. Not really a great teaching book as it doesn't go into the building the language code, but the examples are great and a beginner will pick up a lot of tricks. My only criticism is that the book wasn't...

A welcome edition to my reference library.

I've always been a fan of the Master Visually series by Wiley Publishers. I have seen many technical books attempt to use a Visual Graphis style to make complex ideas simple and easy to understand. In this edition of "Excel 2003 VBA Programming" authored by Julia Kelly I wasn't disappointed. I give this book such a high rating because it does exactly what it promises in terms of functionality and understanding. There's...

beginners should have this book

This book takes you from recording macros to knowing what the Visual Basic editor is, which is the foundation of writing your own macors. The book explores all the basics that you need to grasp along with providing all the steps visually. There are pictures on each page. It shows how to reference workbooks, sheets, ranges, colunms and row statements along with how to make decisions using If Then Else and how to use Loops...

Get THIS ONE FIRST

If there is one thing I know about trying to learn any computer program, it is that you have to get over the fear of the unknown and try it out to see how it works. This book gives you the exact keystrokes to use and pictures of what you should get step by step. I've tried almost all of the routines and found very few errors. After going through this book you will be familiar with the syntax of VBA, how it is structured...

The best reference out there!

I work in a corporate environment and have found this book to be invaluable -- even in the short two week's I've owned it. Hardly a day goes by when I don't need to find a little VBA technique to help me create useful Excel apps for our team, and this book thus far has not let me down. It's accessible, targeted and concise. Highly recommended.