Master Visually Excel 2003 VBA Programming [Paperback]

Julia Kelly (Author)

Book Description

ISBN-10: 0764579738 | ISBN-13: 978-0764579738 | Publication Date: February 18, 2005 | Edition: 1

* 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

Editorial Reviews

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.

Product Details

• Paperback: 432 pages
• Publisher: Visual; 1 edition (February 18, 2005)
• Language: English
• ISBN-10: 0764579738
• ISBN-13: 978-0764579738
• Product Dimensions: 11.2 x 8.3 x 1 inches
• Shipping Weight: 1.9 pounds
• Average Customer Review: 3.5 out of 5 stars  See all reviews (12 customer reviews)
• Amazon Best Sellers Rank: #896,931 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

20 of 21 people found the following review helpful:

5.0 out of 5 stars The best reference out there!, March 9, 2005

By 

Robert G. (Vista, CA) - See all my reviews

This review is from: Master Visually Excel 2003 VBA Programming (Paperback)

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.

11 of 11 people found the following review helpful:

5.0 out of 5 stars Get THIS ONE FIRST, June 9, 2006

By 

B. Nicholson "excel guru wannabee" (Evansville, IN) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Master Visually Excel 2003 VBA Programming (Paperback)

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 and see how it manipulates your spreadsheets in very practical ways that you can use today. You will find yourself keeping these small routines and copying them around in your larger more complex routines.

My only complaint is that sometimes it is hard to read the difference between a period and a comma. As you grow to learn VBA, this complaint lessens however. This is a minor complaint, and certainly not enough to recommend this book less.


I also own VBA Power Programming by Walkenbach, that book, will come ALIVE after you try all the procedures in THIS book.

11 of 12 people found the following review helpful:

4.0 out of 5 stars beginners should have this book, August 27, 2006

By 

C. Johnson (NY USA) - See all my reviews
(REAL NAME)   

This review is from: Master Visually Excel 2003 VBA Programming (Paperback)

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. Additional topics are charts, pivot tables and user forms. Check out the table of contents for a more information on topics covered.

The reason I gave it only 4 stars instead of 5 is that nowhere in the title or elsewhere does it state its a beginner book. With a title VBA Programming I expected indepth coverage of programming with the excel objects. I was looking more for a intermediate or advanced book.