Product Description

What is this book about?

VBA is the programming language for the Microsoft Office suite and many other applications. VBA gives you complete control of Excel, allowing you to do anything from automating Excel tasks to developing full applications, using Excel as the development environment.

Excel 2002 is an important upgrade to the Office suite spreadsheet program. It shows Microsoft′s commitment to moving Office to be a web–enabled productivity tool, a rich client for working with web–based data, with new features such as SmartTags and XML support.

Based on the successful content and format of Excel 2000 VBA Programmer′s Reference, this new edition has been fully updated for Excel 2002. The authors are all Excel MVPs, involved daily in supporting the Excel VBA programmer community.

What does this book cover?

The first part of the book introduces Excel and VBA, including a VBA primer. The second part offers thematic, succinct, and practical discussions of the features available to Excel VBA programmers, with real–world examples answering frequently asked questions. The third and final part is a complete reference to the Excel, VBE, and Common Office Object Models.

Here are just a few of the things you′ll learn in this edition:

• The entire Excel Object Model and the Common Office Object Model
• Working with PivotTables
• Accessing and manipulating data sources from Excel with ADO
• Programming the Visual Basic Editor (VBE)
• New features in Excel 2002, SmartTags, XML, and the Web
• Expanded references for Excel versions 97, 2000, and 2002

Who is this book for?

This book not only caters for beginner– and intermediate–level programmers with its introductory coverage of VBA and Excel, but also provides advanced information for experienced Excel developers in later chapters and the reference.

Product Details

• Amazon Sales Rank: #271784 in Books
• Published on: 2001-09-26
• Original language: English
• Number of items: 1
• Binding: Paperback
• 1032 pages

From the Back Cover
VBA is the programming language for the Microsoft® Office suite and many other applications. VBA gives you complete control of Excel, allowing you to do anything from automating Excel tasks to developing full applications, using Excel as the development environment.

Excel 2002 is an important upgrade to the Office suite spreadsheet program. It shows Microsoft’s commitment to moving Office to be a web–enabled productivity tool, a rich client for working with web–based data, with new features such as SmartTags and XML support.

Based on the successful content and format of Excel 2000 VBA Programmer’s Reference, this new edition has been fully updated for Excel 2002. The authors are all Excel MVPs, involved daily in supporting the Excel VBA programmer community.

The first part of the book introduces Excel and VBA, including a VBA primer. The second part offers thematic, succinct, and practical discussions of the features available to Excel VBA programmers, with real–world examples answering frequently asked questions. The third and final part is a complete reference to the Excel, VBE, and Common Office Object Models.

Who is this book for?

This book not only caters for beginner and intermediate–level programmers with its introductory coverage of VBA and Excel, but also provides advanced information for experienced Excel developers in later chapters and the reference.

What does this book cover?

• The entire Excel Object Model and the Common Office Object Model
• Working with PivotTables
• Accessing and manipulating data sources from Excel with ADO
• Programming the Visual Basic® Editor (VBE)
• New features in Excel 2002, SmartTags, XML, and the Web
• Expanded references for Excel versions 97, 2000, and 2002

As an experienced developer, you need to get the facts on a new technology fast. Without the marketing hype, without the trivial introduction. That’s what Wrox Programmer’s References deliver. Hard facts on the newest technologies with practical examples of how to apply new tools to your development projects today.

About the Author
John Green works as an independent computer consultant and established his company, Execuplan Consulting, which specializes in developing computer based planning applications and in training. He′s led training courses for software applications and operating systems and has been accorded the status of Most Valuable Professional by Microsoft for his contributions to the CompuServe Excel forum and MS Internet newsgroups. Contact him at jgreen@enternet.com.au.

Stephen Bullen set–up his own company called Business Modelling Solutions Ltd, which specialises in Excel and Access development and consulting. The BMS web site contains a large number of examples of his work, including tools and utilities to extend Excel′s functionality and many examples of Excel development techniques. Stephen can be contacted by email to Stephen@BMSLtd.co.uk.

Rob Bovey is a software developer and is founder and president of the custom application development firm, Application Professionals. Rob developed several Addins shipped by Microsoft for Excel. He also co–authored the Microsoft Excel 97 Developers Kit. Microsoft has awarded him the title of Most Valuable Professional each year since 1995.

Robert Rosenberg runs his own consulting business which specializes in Microsoft Office advanced training and custom solutions. As a Microsoft Valuable Professional in Excel, he also continually offers advanced online support on Excel on behalf of Microsoft to users of their Internet newsgroups. Robert can be contacted on at rrosenberg@r–cor.com.

Customer Reviews

Concise, easy to follow & understand reference guide to VBA
This is the most concise Excel VBA guide I have read so for. Absolutely everything is covered in it. It's really easy follow and use. Don't be put off by the title of Excel 2002. It covers the last three versions and makes specific references to any details that may not be relevant to older versions. If you're a beginner,it introduces you very quickly to writing code. So you may be better getting a more basic guide, but for users that are familiar already with VBA to those who would consider themselves 'guru's', it's a must.

The advanced excel user's guide to truly mastering excel
This book is excellent for learning the basics about Excel programming all the way through to an expert user.

Many books claim to teach the advanced parts of Excel but I have been dissapointed in that they do not go all the way as promised.

I am an advanced user of Excel and needed a book that would go beyond pivot tables, basic VBA and macros. This book takes you to furthest and most advanced parts of Excel in a very easy to understand format to develop applications that are truly powerful. I have automated manual processes through this book that has led to several man-days worth of savings in time.

Whenever I have wanted a book that will help me master an application, I have turned to Wrox and they have never let me down!

I would recommend this book as a day to day reference for beginners in VBA/Macro programming to advanced users who really need to tap into the potential of Excel.

Excellent for all levels
I am a self taught VBA programmer and as such I needed a book that would take me that much further, as well as allowing me to brush up on any basics I may have missed. This book does that in volumes. The VBA Primer at the beginning of the book is good enough to get anyone started in VBA right from the beginning, and as the book goes on it goes into more difficult tasks with plenty of sample code. The reference is concise and useful, and it makes a perfect desktop companion. In fact, the only gripe I have about it is it would have been nice to have a CD supplied with it with all the sample code on. Oh well, can't have everything!
Definately worth the money.