Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series)
by Stephen Bullen, Rob Bovey, John Green
Our Price: $55.23
Availability: Usually ships in 1-2 business days
Buy Used: from $49.89 (click here)
Category: Book
See more book details and other editions
Book Summary Information
Author: John Green, Rob Bovey, Stephen BullenEdition: Paperback
Audio: English (Published)
Format: Bargain Price
Published: 2005-02-11
ISBN: N/A
Number of pages: 936
Publisher: Addison-Wesley Professional
Book Reviews of Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series)
Book Review: Uh-oh! Be careful!
Summary: 3 Stars
This book of advanced Excel development was recommended to me by a co-worker whose project I inherited that used the concepts in the book based on the "Petras Template" example. It's classy and polished VBA programming and sure, you can brag about the concepts to the techies interviewing you during your next job hunt.
But, be careful.
The book introduces us to the concept of add-ins and templates. So, there you are showing off your project to your manager or users. But, what do they click on? The add-in or the template? What are all those true/false cells over there? How can the user save the workbook? What heppens if you forget to hide the columns that use cell logic. Hmmm. These questions and others will be asked of your typically non-technical users who have NO idea what goes on behind the scenes. If they open up the template and screw around with the code or re-name the add-in, you'll have chaos.
To be fair, there's tons of advanced concepts to learn here and no doubt you'll benefit from them. But, remember, as a developer, your first goal is to produce a robust application. However, you may have click a couple of functions to get all tabs in your template to show. If you don't do that, you can't see them! Oh, and don't forget to save your add-in.xla or all your changes won't take effect.
Not for beginners or dummies, but for VERY careful developers!
More Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series) reviews:
1 2 3 4 5 6
1 2 3 4 5 6
Summary of Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series)
Finally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications. This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's knowledge they've acquired building Excel applications for many of the world's largest companies-including Microsoft. Professional Excel Development demonstrates how to get the utmost from Excel, addressing everything from application architectures through worksheet and userform design, charting, debugging, error handling and optimizing performance. Along the way, the authors offer best practices for every type of Excel development, from building add-ins through interacting with XML Web services. Coverage includes- Building add-ins to provide new Excel functions
- Designing effective worksheets, userforms and other user interface elements
- Leveraging Excel's powerful data analysis features
- Creating sophisticated custom charts
- Handling errors, debugging applications and optimizing performance
- Using class modules and interfaces to create custom objects
- Understanding Windows API calls: when to use them, and how to modify them
- Adding worksheet functions with C-based XLLs
- Programming with databases
- Controlling external applications from Excel
- Integrating with Visual Basic 6, VB.NET and Visual Studio Tools for Office
- Using XML to import and export data and communicate with Web services
- Providing help, securing, packaging and distributing
?
VBA Books
Book Subjects
- Arts & Photography
- Audiobooks on Cassette
- Audiobooks on CD
- Biographies & Memoirs
- Business & Investing
- Children's Books
- Comics & Graphic Novels
- Computers & Internet
- Cooking, Food & Wine
- e-Books
- Engineering
- Entertainment
- Gay & Lesbian
- Health, Mind & Body
- History
- Home & Garden
- Horror
- Law
- Literature & Fiction
- Medicine
- Mystery & Thrillers
- Nonfiction
- Outdoors & Nature
- Parenting & Families
- Professional & Technical
- Reference
- Religion & Spirituality
- Romance
- Science
- Science Fiction & Fantasy
- Sports
- Teens
- Travel
Most talked about in VBA Programming
Excel 2003 VBA Programmer's Reference (Programmer to Programmer)by Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg
Wrox; Published: 2004-07-09; Paperback; Book
Best price: $11.30
Price in other shops:
Excel 2003 Power Programming with VBA (Excel Power Programming With Vba)by John Walkenbach
For Dummies; Published: 2004-01-13; Paperback; Book
Best price: $28.22
Price in other shops:
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series)by Stephen Bullen, Rob Bovey, John Green
Addison-Wesley Professional; Published: 2005-02-11; Paperback; Book
Best price: $18.99
Price in other shops:
Similar Books and other products
Excel 2003 Bibleby John Walkenbach
Wiley; Published: 2003-09-19; Paperback; Book
Best price: $22.31
Price in other shops:
Excel 2003 Formulasby John Walkenbach
For Dummies; Published: 2003-10-17; Paperback; Book
Best price: $23.95
Price in other shops:
Pivot Table Data Crunching (Business Solutions)by Bill Jelen, Michael Alexander
Que; Published: 2005-07-01; Paperback; Book
Best price: $20.87
Price in other shops:
Excel 2007 VBA Programmer's Reference (Programmer to Programmer)by John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Wrox; Published: 2007-03-26; Paperback; Book
Best price: $15.70
Price in other shops:
Programming Excel with VBA and .NET (Programming)by Jeff Webb, Steve Saunders
O'Reilly Media, Inc.; Published: 2006-04-25; Paperback; Book
Best price: $30.01
Price in other shops:
Integrating Excel and Accessby Michael Schmalz
O'Reilly Media, Inc.; Published: 2005-11-01; Paperback; Book
Best price: $21.50
Price in other shops:
Excel VBA Programming For Dummies (For Dummies (Computer/ Tech))by John Walkenbach
For Dummies; Published: 2004-08-20; Paperback; Book
Best price: $13.41
Price in other shops:
Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)by John Walkenbach
Wiley; Published: 2007-04-16; Paperback; Book
Best price: $25.93
Price in other shops:
Excel Advanced Report Developmentby Timothy Zapawa
Wiley; Published: 2005-07-29; Paperback; Book
Best price: $21.33
Price in other shops:
Excel 2003 Power Programming with VBA (Excel Power Programming With Vba)by John Walkenbach
For Dummies; Published: 2004-01-13; Paperback; Book
Best price: $28.22
Price in other shops: