Product Description

Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topics are covered that are sure to give you a solid knowledge of the VBA language. Event programming, user forms, carts, pivot tables, multi-dimensional arrays and Web queries are just a few of the areas you will learn about in this book. Written by the principal behind the leading Excel Web site, www.mrexcel.com, this book is sure to save you time and money!

Product Details

• Amazon Sales Rank: #62935 in Books
• Published on: 2004-05-20
• Original language: English
• Number of items: 1
• Binding: Paperback
• 576 pages

From the Back Cover

Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topics are covered that are sure to give you a solid knowledge of the VBA language. Event programming, user forms, carts, pivot tables, multi-dimensional arrays and Web queries are just a few of the areas you will learn about in this book. Written by the principal behind the leading Excel Web site, www.mrexcel.com, this book is sure to save you time and money!

About the Author

Bill Jelen "Mr. Excel" is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 10 million page views annually. Prior to founding MrExcel.com, Jelen spent twelve years in the trenches, working as a financial analyst for finance, marketing, accounting and operations departments of a $500 million public company.

Tracy Syrstad works as an Excel and Access Consultant. As part of the Mr.Excel.com Consulting team, she has helped develop VBA solutions for clients around the world. She remembers the painful trek up the VBA learning curve while developing applications for co-workers at a former job. She is co-editor of Holy Macro!, it¿s ֿ,600 Excel VBA Examples CD” and editor of Dreamboat On Word.

Customer Reviews

An excellent buy. Far more useful than those 500+ page "everything about..." tomes
This is one of those rare things, a technical "how to" book that actually delivers more than it claims on the cover. It is unintimidating, easy to read, and there's a really useful nugget of information on almost every page. As an example, although ostensibly focused only on Excel Macro programming, this book along the way clarifies some critical details on both Excel Pivot Tables and R1C1 cell referencing that another 850-page "comprehensive" book on Excel completely failed to mention.

VBA & Macros for Excel
Mr Excel has written yet another great book about Excel, over 500 pages of highly informative stuff, great examples and its all written in an easy to use format.(The explanation of VBA speech is great.)

As a Excel power user for several years I'm always looking for something to give me the edge and make mine or my co-workers life that little easier. This book does, as do the rest of the Mr Excel / Holy Macros titles.

Want to learn VBA - Go Buy!!

Could do better
This book spends too much time giving you "cool" examples "to impress your clients" and not enough time explaining the syntax of the language. Also, the book does assume a little more in the way of programming knowledge than it claims, e.g. use of DIM statement is never explained.

All I wanted from a VBA manual was a dry, comprehensive syntax/semantics-oriented guide. What this book does is give small examples of what individual properties can do, then build these up into 'useful' macros. The problem is that if you want to write some code slightly different to the example given in the book, it takes a lot of digging to find out how.