Excel 2007 VBA Programmer's Reference (Programmer to Programmer) (Paperback)

~ (Author), Stephen Bullen (Author), Rob Bovey (Author), (Author)
Key Phrases: oleobj ect, smith mangoes, offline cube file, Private Sub, Error Resume Next, Exit Sub (more...)

Editorial Reviews

Product Description

Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats.

From the Back Cover

Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats.

In order to master all of the new features of this program, you'll find an introduction to VBA and details on how to use it to enhance Excel. You'll then learn how to work with the key objects and uncover the best ways to gain access to workbooks, worksheets, charts, and more. And you'll find out how to write code for international compatibility, program the Visual Basic Editor, and use the functions in the Win32 API, which will expand your Excel VBA programming skills.

What you will learn from this book

• How to write code that is readable, easy to maintain, and runs at maximum speed

• Tips for utilizing the Visual Basic® Editor and its multitude of tools

• Techniques for accessing data in a range of formats

• Ways to set up your applications and convert them to add-ins

• How to manipulate the Office XML file formats

• A thorough explanation of RibbonX

• Best practices for managing external data and using OLAP data sources

• Methods for effectively debugging your application

• Tips for packaging and distributing customized applications to other users

Who is this book for?

This book is for Excel users and programmers from beginning to advanced. You should have a reasonable working knowledge of Excel and a full installation of the software.

Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.

See all Editorial Reviews

Product Details

• Paperback: 1176 pages
• Publisher: Wrox (March 26, 2007)
• Language: English
• ISBN-10: 0470046430
• ISBN-13: 978-0470046432
• Product Dimensions: 9.2 x 7.2 x 2.2 inches
• Shipping Weight: 3.4 pounds (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars  See all reviews (8 customer reviews)
• Amazon.com Sales Rank: #32,575 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #6 in	Books > Computers & Internet > Microsoft > Development > VBA
  #29 in	Books > Computers & Internet > Software > Spreadsheets
  #45 in	Books > Computers & Internet > Software > Business > Accounting

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

4.0 out of 5 stars Pretty good book if you have background in programming with other language, October 30, 2008

By	Qi Zhong - See all my reviews (REAL NAME)

Amazon Verified Purchase

I started working for a hedge fund when I brought this book because I don't know how to use VBA, and impressed my colleages with my rapid improvement in VBA programming. It helps a lot and have a lot of good tricks. Will be very useful if you know some level of programming.

8 of 10 people found the following review helpful:

5.0 out of 5 stars Required Reference for Excel 2007 VBA, September 7, 2007

By	High Hoop (Bolton, CT USA) - See all my reviews

The brief treatment of VBA syntax and the power of VBA make this text for intermediate users and above in my opinion.

Its broad scope, covering command bars, class modules, ribbonx, open XML and much more make it a source to be mined over time. As a reader's knowledge increases, he is likely to find first one and then another Excel feature that can be utilized using techniques described in this text.

2 of 2 people found the following review helpful:

5.0 out of 5 stars Didn't know a lick of VBA of ANY type going in, February 20, 2009

By	Bill R. O. Neal "flyinbill" (Cleveland, Ohio) - See all my reviews (REAL NAME)

I used this book to finalize an Excel project promised to a client that I soon realized would require some kind of programming. I do have a programming background and I think that always helps, but I think even w/o that, this book may just do the trick for anybody (It even has a section to teach some basic programming skills and show these skills using VBA for Excel.)

The project was successful only because of this book (and my hard work! - but we're not reviewing that here! ;-)

Worth every pennny.