Absolutely Australia's Lowest Prices

Shop over 1.5 Million Toys in our Huge New Range

"As Excel applications become more complex and the Windows development platform more powerful, Excel developers need books like this to help them evolve their solutions to the next level of sophistication. Professional Excel Development is a book for developers who want to build powerful, state-of-the-art Excel applications using the latest Microsoft technologies."-Gabhan Berry, Program Manager, Excel Programmability, Microsoft "The first edition of Professional Excel Development is my most-consulted and most-recommended book on Office development. The second edition expands both the depth and range. It shines because it takes every issue one step further than you expect. The book relies on the authors' current, real-world experience to cover not only how a feature works, but also the practical implications of using it in professional work."-Shauna Kelly, Director, Thendara Green "This book illustrates techniques that will result in well-designed, robust, and maintainable Excel-based applications. The authors' advice comes from decades of solid experience of designing and building applications. The practicality of the methods is well illustrated by the example timesheet application that is developed step-by-step through the book. Every serious Excel developer should read this and learn from it. I did."-Bill Manville, Application Developer, Bill Manville Associates The Start-to-Finish Guide to Building State-of-the-Art Solutions with Excel 2007 In this book, four world-class Microsoft (R) Excel developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors-three of whom have been honored by Microsoft as Excel Most Valuable Professionals (MVPs)-show how to consistently make the right design decisions and make the most of Excel's most powerful new features. Using their techniques,you can reduce development costs, time to market, and hassle-and build more effective, successful solutions. Fully updated for Excel 2007, this book starts where other books on Excel programming leave off. Through a hands-on case study project, you'll discover best practices for planning, architecting, and building Excel applications that are robust, secure, easy to maintain, and highly usable. If you're a working developer, no other book on Excel programming offers you this much depth, insight, or value. * Design worksheets that will be more useful and reliable* Leverage built-in and application-specific add-ins* Construct applications that behave like independent Windows programs* Make the most of the new Ribbon user interface* Create cross-version applications that work with legacy versions of Excel* Utilize XML within Excel applications* Understand and use Windows API calls* Master VBA error handling, debugging, and performance optimization* Develop applications based on data stored in Access, SQL Server, and other databases* Build powerful visualization solutions with Excel charting engine * Learn how to work with VB.NET and leverage its IDE* Automate Microsoft Excel with VB.NET* Create managed COM add-ins for Microsoft Excel with VB.NET* Develop Excel solutions with Visual Studio Tools for Office (VSTO)* Integrate Excel with Web Services* Deploy applications more securely and efficiently
Product Details

Table of Contents

Acknowledgments . . . xivAbout the Authors . . . xvChapter 1 IntroductionAbout This Book . . . 1Who Should Read This Book . . . 2Excel Developer Categories . . . 2Excel as an Application Development Platform . . . 4Structure . . . 7Examples . . . 8Supported Versions of Excel . . . 9Typefaces . . . 10On the CD . . . 10Help and Support . . . 11The Professional Excel Development Web Site . . . 12Feedback . . . 12Chapter 2 Application ArchitecturesConcepts . . . 13Chapter 3 Excel and VBA Development Best PracticesNaming Conventions . . . 27Best Practices for Application Structure and Organization . . . 40General Application Development Best Practices . . . 45Chapter 4 Worksheet DesignPrinciples of Good Worksheet UI Design . . . 69Program Rows and Columns: The Fundamental UI Design Technique . . . 70Defined Names . . . 71Styles . . . 78User Interface Drawing Techniques . . . 83Data Validation . . . 88Conditional Formatting . . . 92Using Controls on Worksheets . . . 98Practical Example . . . 100Chapter 5 Function, General, and Application-Specific Add-insThe Four Stages of an Application . . . 107Function Library Add-ins . . . 110General Add-ins . . . 117Application-Specific Add-ins . . . 118Practical Example . . . 125Chapter 6 Dictator ApplicationsStructure of a Dictator Application . . . 141Practical Example . . . 157Chapter 7 Using Class Modules to Create ObjectsCreating Objects . . . 166Creating a Collection . . . 170Trapping Events . . . 177Raising Events . . . 180Practical Example . . . 188Chapter 8 Advanced Command Bar HandlingCommand Bar Design . . . 198Table-Driven Command Bars . . . 199Putting It All Together . . . 219Loading Custom Icons from Files . . . 228Hooking Command Bar Control Events . . . 232Practical Example . . . 241Chapter 9 Introduction to XMLXML . . . 249Chapter 10 The Office 2007 Ribbon User InterfaceThe RibbonX Paradigm . . . 273An Introduction to the Office 2007 Open XML File Format . . . 274Ribbon Design and Coding Best Practices . . . 278Table-Driven Ribbon UI Customization . . . 289Advanced Problem Solving . . . 291Further Reading . . . 300Related Portals . . . 300Chapter 11 Creating Cross-Version ApplicationsCommand Bar and Ribbon User Interfaces in a Single Application . . . 304Other Excel 2007 Development Issues . . . 319Windows Vista Security and Folder Structure . . . 326Chapter 12 Understanding and Using Windows API Calls Overview . . . 331Working with the Screen . . . 337Working with Windows . . . 340Working with the Keyboard . . . 349Working with the File System and Network . . . 355Practical Examples . . . 369Chapter 13 UserForm Design and Best PracticesPrinciples . . . 375Control Fundamentals . . . 384Visual Effects . . . 392UserForm Positioning and Sizing . . . 400Wizards . . . 407Dynamic UserForms . . . 411Modeless UserForms . . . 419Control Specifics . . . 425Practical Example . . . 432Chapter 14 InterfacesWhat Is an Interface? . . . 433Code Reuse . . . 435Defining a Custom Interface . . . 437Implementing a Custom Interface . . . 438Using a Custom Interface . . . 440Polymorphic Classes . . . 443Improving Robustness . . . 448Simplifying Development . . . 448A Plug-in Architecture . . . 460Practical Example . . . 462Chapter 15 VBA Error HandlingError Handling Concepts . . . 465The Single Exit Point Principle . . . 475Simple Error Handling . . . 475Complex Project Error Handler Organization . . . 476The Central Error Handler . . . 481Error Handling in Classes and UserForms . . . 488Putting It All Together . . . 490Practical Example . . . 496Chapter 16 VBA DebuggingBasic VBA Debugging Techniques . . . 507The Immediate Window (Ctrl+G) . . . 517The Call Stack (Ctrl+L) . . . 521The Watch Window . . . 522The Locals Window . . . 532The Object Browser (F2) . . . 533Creating and Running a Test Harness . . . 537Using Assertions . . . 540Debugging Shortcut Keys That Every Developer Should Know . . . 542Chapter 17 Optimizing VBA PerformanceMeasuring Performance . . . 545The PerfMon Utility . . . 546Creative Thinking . . . 551Macro-Optimization . . . 556Micro-Optimization . . . 567Chapter 18 Introduction to Database DevelopmentAn Introduction to Databases . . . 577An Introduction to SQL . . . 594Data Access with ADO . . . 598Further Reading . . . 613Chapter 19 Programming with Access and SQL ServerA Note on the Northwind Sample Database . . . 615Designing the Data Access Tier . . . 616Working with Microsoft Access Databases . . . 620Working with Microsoft SQL Server Databases . . . 630Upsizing from Access to SQL Server . . . 642Further Reading . . . 647Practical Example . . . 648Chapter 20 Data Manipulation TechniquesExcel's Data Structures . . . 661Data Processing Features . . . 667Advanced Functions . . . 678Chapter 21 Advanced Charting TechniquesFundamental Techniques . . . 687VBA Techniques . . . 702Chapter 22 Controlling Other Office ApplicationsFundamentals . . . 709The Primary Office Application Object Models . . . 725Further Reading . . . 739Practical Example . . . 740Chapter 23 Excel and Visual Basic 6A Hello World ActiveX DLL . . . 742Why Use VB6 ActiveX DLLs in Excel VBA Projects . . . 758In-Process Versus Out-of-Process . . . 774Automating Excel from a VB6 EXE . . . 775COM Add-ins . . . 783A "Hello World" COM Add-in . . . 783The Add-in Designer . . . 788Installation Considerations . . . 790The AddinInstance Events . . . 792Command Bar Handling . . . 795Why Use a COM Add-in? . . . 798Automation Add-ins . . . 799Practical Examples . . . 802Chapter 24 Excel and VB.NET.NET Framework Fundamentals . . . 818Visual Basic.NET . . . 819Debugging . . . 845Useful Development Tools . . . 853Automating Excel . . . 855Resources in .NET Solutions . . . 863Retrieving Data with ADO.NET . . . 864Further Reading . . . 870Additional Development Tools . . . 871Q&A Forums . . . 871Practical Example-PETRAS Report Tool .NET . . . 872Chapter 25 Writing Managed COM Add-ins with VB.NETChoosing a Development Toolset . . . 890Creating a Managed COM Add-in . . . 891Building the User Interface . . . 908Creating Managed Automation Add-ins . . . 928Manually Register and Unregister COM Add-ins . . . 940Using Classes in VB.NET . . . 940Using Classic ADO to Export Data to Excel . . . 948Shimming COM Add-ins . . . 952Related Blogs . . . 962Additional Development Tools . . . 962Practical Example-PETRAS Report Tool.NET . . . 963Chapter 26 Developing Excel Solutions with Visual Studio Tools for Office System (VSTO)What Is VSTO? . . . 976When Should You Use VSTO? . . . 983Working with VSTO Add-Ins . . . 985Working with VSTO Templates and Workbook Solutions . . . 1006Deployment and Security . . . 1016Further Reading . . . 1026Related Portal and Blogs . . . 1026Additional Development Tools . . . 1026Chapter 27 XLLs and the C APIWhy Create an XLL-Based Worksheet Function . . . 1029Creating an XLL Project in Visual Studio . . . 1030The Structure of an XLL . . . 1034The XLOPER and OPER Data Types . . . 1044The Excel4 Function . . . 1050Commonly Used C API Functions . . . 1052XLOPERs and Memory Management . . . 1053Registering and Unregistering Custom Worksheet Functions . . . 1054Sample Application Function . . . 1057Debugging the Worksheet Functions . . .1060Miscellaneous Topics . . .1061Additional Resources . . . 1062Chapter 28 Excel and Web ServicesWeb Services . . . 1065Practical Example . . . 1072Chapter 29 Providing Help, Securing, Packaging, and DistributingProviding Help . . . 1085Securing . . . 1094Packaging . ..1099Distributing . . . 1104Index . . . 1107

About the Author

Rob Bovey, President of Application Professionals, has developed several Excel add-ins shipped by Microsoft. He coauthored the Microsoft Excel 97 Developers Kit and Excel 2007 VBA Programmer's Reference.Dennis Wallentin has developed Excel solutions since the 1980s through his firm, XL-Dennis, based in OEstersund, Sweden.Stephen Bullen, coauthor of The Excel 2007 VBA Programmer's Reference, owns Office Automation, Ltd., based in Essex, Ireland.John Green owns Execuplan Consulting, a Sydney, Australia-based consultancy specializing in Excel and Access development. Bovey, Bullen, and Green hold Microsoft's prestigious Most Valuable Professional (MVP) honor.

Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .Net [With CDROM] on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond.com, Inc.
Back to top