Excel 2007 Power Programming with VBA (Mr. Spreadsheet's...

Features

• Cover Type: Paperback with 1061 pages
• Published by: Wiley; Pap/Cdr edition April 16, 2007
• Written in: English
• ISBN 10 Number: 0470044012
• ISBN 13 Number: 978-0470044018
• Book Dimensions: 9.2 x 7.3 x 2.5 inches
• Weighs: 2.9 pounds

Book Description

• This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
• Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
• John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel
• Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
• Includes a valuable CD-ROM with templates and worksheets from the book

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Back Cover Copy
Expand Excel with VBA, and feel the power!

No one is better at revealing the secrets of Excel than "Mr. Spreadsheet" himself. This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic® for Applications. Excel 2007 has a few new tricks up its sleeve, and John Walkenbach helps you make the most of them all.

You'll learn to customize Excel UserForms, develop new utilities, use VBA with charts and PivotTables, and create event-handling applications. Work with VBA subprocedures and function procedures, facilitate interactions with other applications, build easy to use toolbars, menus, and help systems, and much more. Get ready to make Excel do your bidding.

Mr. Spreadsheet's POWER TIPS:

Power Tip #1 Create powerful Excel applications

Power Tip #2 Enhance Excel with VBA macros

Power Tip #3 Write event-driven VBA code

Power Tip #4 Understand the new Excel 2007 ribbon

Power Tip #5 Expand Excel's shortcut menus

CD-ROM INCLUDES:

• Valuable sample files that illustrate examples from the text
• 
  
  A searchable PDF version of the book

See the CD appendix for details and complete system requirements.

Reader Reviews
This is a GREAT introduction to ALL aspects of Excel and VBA. Most people who need this book come into VBA from other experiences and have rarely taken classes in VBA and they need a readable reference that can bring them up to speed on the parts they don't understand yet. Used this way the book is simply outstanding and most users probably don't need anything more than this book, but I'm not one of those people. I purchased "Professional Excel Development" by Bullen, Bovey, and Green at the same time and was awestruck at the depth of their knowledge and their passion for making Excel the only development tool your company will ever need. Personally I think they are absolutely nuts in a very knowledgeable and useful way. The biggest problem with "Professional Excel Development" is that readers are expected to know a LOT more about Excel and VBA than average and Walkenbach nicely addresses that issue. He's also a lot more readable than the other authors and so can be used in conjunction with them to clarify the points that they are making. Regardless of how you use this book, it is a very good for just about any level of VBA developer and firmly earns the 5 star rating. Comment | | (Report this)