Product Description

∗ 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

Product Details

• Amazon Sales Rank: #277347 in Books
• Published on: 2005-02-22
• Original language: English
• Number of items: 1
• Binding: Paperback
• 432 pages

From the Back Cover
"One picture is worth a thousand words." If you prefer instructions that show you how rather than tell you why, then this intermediate to advanced level reference is for you. Hundreds of succinctly captioned, step–by–step screen shots reveal how to accomplish more than 180 Excel tasks with VBA programming, including:

• Writing and recording short macros
• Using all the VBA commands
• Automating charts, pivot tables, and more
• Adding digital signatures
• Debugging your code
• Specifying page setup settings
• Writing a function procedure

About the Author
Julia Kelly is a writer, teacher, and consultant for desktop applications, including Excel, Access, Word, Publisher, and Outlook. She’s taught classroom courses in Excel at major corporations and Outlook courses on–line for several years, and has authored 17 book on Office applications. In addition, she develops Excel and Access applications for business clients.

Customer Reviews

Provides good building blocks for the newcomer and as a useful reference
I have found this book very useful. I used to program many years ago (FORTRAN, Assembler etc) and never considered Excel VBA (at all!) until I needed to move columns of data from several spreadsheets into rows of a report. It was a means to an end and I wanted to do it in my own time (I wasn't sure how successful I would be) so I decided to find a helpful book to guide me. In fact, it took two helpful books; this and Excel VBA Macro programming (ISBN: 0-07-223144-0). But let's get back to the book in question.

Initially, it felt like reading dictionary (so much information!) but, after getting grips with the Excel VBA world and seeing some logic to it, this book has become my friend. I think somewhere the author, Julia Kelly, says that many of the examples are there as answers to the questions she was repeatedly asked during training sessions. It is amusing to read some of these ready useful responses because I can imagine the scene. For example: "Why do I get an error the second time I run this macro"; answer: "the component you are trying to create was created the first time around". There are many (more positive!) examples as well and it is this attention to detail that makes this book so enjoyable to read. (The jury is still out on whether reading about Excel VBA is enjoyable!). The chapters are grouped into seven parts, each preceded by a summary, so searching for a solution is made that much easier. The examples are described very well, with the spreadsheet, VBA screen and, where appropriate, a form on the right of the page, being supported by explanations on the left. While this book provided me with the building blocks, as a dictionary would provide words, it did not provide me with the knowledge I needed to develop the flexible software. I needed another book to supply me with some sentences! This was provided by the second book: Excel VBA Macro programming.

Although I have had this book, Master Visually Excel 2003 VBA Programming, for several months, I still find that this collection of simple but well explained examples a valuable reference. I also like its rigour.