|
 |
|
 |
 |
Excel 2007 VBA Programmer's Reference (Programmer to Programmer)
|
by John Green, Stephen Bullen, Rob Bovey, and Michael Alexander
Sales Rank: 37085
|
Discount: 34 %
List Price: $39.99
$26.39
At Amazon
|
|
Paperback: 1143 pages
Publisher: Wrox March 26, 2007
Language: English
ISBN-10: 0470046430
ISBN-13: 978-0470046432
Product Dimensions:
9.2 x 7.4 x 2.3 inches
Shipping Weight: 3.3 pounds
Book 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.
Back Cover Copy
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.
Customer Reviews & Comments
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.
Comment | Permalink |
(Report this)
|
Excel 2007 VBA Programmer's Reference (Programmer to Programmer)
List Price: $39.99
Discount: 34 %
Available from Amazon
Price: $26.39
| |
|
|
|
|
