Picture 1 of 1
Stock photo
Picture 1 of 1
Stock photo
Professional Excel Development : The Definitive Guide to Developing Applications Using Microsoft Excel and VBA by Rob Bovey, John Green and Stephen Bullen (2005, Trade Paperback)
W***e (4479442)
98.5% positive feedback
Price:
US $5.99
ApproximatelyC $8.26
+ $10.50 shipping
Returns:
30 days return. Buyer pays for return shipping. If you use an eBay shipping label, it will be deducted from your refund amount.
Condition:
- Buy It NowProfessional Excel Development - Paperback - VERY GOOD
Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
About this product
Product Identifiers
PublisherAddison Wesley Professional
ISBN-100321262506
ISBN-139780321262509
eBay Product ID (ePID)43743300
Product Key Features
Number of Pages936 Pages
Publication NameProfessional Excel Development : The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
LanguageEnglish
SubjectSoftware Development & Engineering / General, Desktop Applications / Spreadsheets
Publication Year2005
TypeTextbook
AuthorRob Bovey, John Green, Stephen Bullen
Subject AreaComputers
FormatTrade Paperback
Dimensions
Item Height2 in
Item Weight50.7 Oz
Item Length11.2 in
Item Width7 in
Additional Product Features
Intended AudienceScholarly & Professional
LCCN2004-114575
Dewey Edition22
IllustratedYes
Dewey Decimal005.54
Table Of ContentContents Acknowledgments. About the Authors. 1. Introduction. About This Book The Excel Developer Excel as an Application Development Platform Structure Examples Supported Versions Typefaces On the CD Help and Support Feedback 2. Application Architectures. Concepts Conclusion 3. Excel and VBA Development Best Practices. Naming Conventions Best Practices for Application Structure and Organization General Application Development Best Practices Conclusion 4. Worksheet Design. Principles of Good Worksheet UI Design Program Rows and Columns: The Fundamental UI Design Technique Defined Names Styles User Interface Drawing Techniques Data Validation Conditional Formatting Using Controls on Worksheets Practical Example Conclusion 5. Function, General and Application-Specific Add-ins. The Four Stages of an Application Function Library Add-ins General Add-ins Application-Specific Add-ins Practical Example Conclusion 6. Dictator Applications. Structure of a Dictator Application Practical Example Conclusion 7. Using Class Modules to Create Objects. Creating Objects Creating a Collection Trapping Events Raising Events Practical Example Conclusion 8. Advanced Command Bar Handling. Command Bar Design Table-Driven Command Bars Putting It All Together Loading Custom Icons from Files Hooking Command Bar Control Events Practical Example Conclusion 9. Understanding and Using Windows API Calls. Overview Working with the Screen Working with Windows Working with the Keyboard Working with the File System and Network Practical Examples Conclusion 10. Userform Design and Best Practices. Principles Control Fundamentals Visual Effects Userform Positioning and Sizing Wizards Dynamic Userforms Modeless Userforms Control Specifics Practical Examples Conclusion 11. Interfaces. What Is an Interface? Code Reuse Defining a Custom Interface Implementing a Custom Interface Using a Custom Interface Polymorphic Classes Improving Robustness Simplifying Development A Plug-in Architecture Practical Example Conclusion 12. VBA Error Handling. Error-Handling Concepts <p style="MARGIN: 0in 0in
SynopsisEnterprise-Class Excel Programming, from Start to FinishFinally, 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. 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 distributionCD-ROM INCLUDEDThe accompanying CD-ROM contains the book's sample timesheet application at every stage of construction, with detailed code comments. It also includes many examples of the concepts introduced in each chapter and a collection of the authors' Excel development utilities.(c) Copyright Pearson Education. All rights reserved., Microsoft Excel can be much more than just a spreadsheet. It has become adevelopment platform in it own right. Applications written using Excel are partof many corporations' core suites of business-critical applications. In spite ofthis, Excel is too often thought of as a hobbyist's platform. While there arenumerous titles on Excel and VBA, until now there have been none thatprovide an overall explanation of how to develop professional-quality Excel-basedapplications. All three authors are professional Excel developers who runtheir own companies developing Excel-based apps for clients ranging fromindividuals to the largest multinational corporations. In this book they showhow anyone from power users to professional developers can increase thespeed and usefulness of their Excel-based apps., Microsoft Excel can be much more than just a spreadsheet. It has become a development platform in it own right. Applications written using Excel are part of many corporations' core suites of business-critical applications. In spite of this, Excel is too often thought of as a hobbyist's platform. While there are numerous titles on Excel and VBA, until now there have been none that provide an overall explanation of how to develop professional-quality Excelbased applications. All three authors are profesional Excel developers who run their own companies developing Excel-based apps for clients ranging from individuals to the largest multinational corporations. In this book they show how anyone from power users to professional developers can increase the speed and usefulness of their Excel-based apps.
LC Classification NumberHF5548.4.M523
