LEADER 05210nam 2200649Ia 450 001 9910780447603321 005 20230617011013.0 010 $a1-280-52218-6 010 $a9786610522187 010 $a0-7821-5105-1 010 $a1-4175-0798-5 035 $a(CKB)111090529113868 035 $a(EBL)267302 035 $a(OCoLC)560243658 035 $a(SSID)ssj0000198739 035 $a(PQKBManifestationID)11954287 035 $a(PQKBTitleCode)TC0000198739 035 $a(PQKBWorkID)10184353 035 $a(PQKB)10148848 035 $a(MiAaPQ)EBC267302 035 $a(Au-PeEL)EBL267302 035 $a(CaPaEBR)ebr10131923 035 $a(CaONFJC)MIL52218 035 $a(OCoLC)181839788 035 $a(EXLCZ)99111090529113868 100 $a20040512d2004 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMastering Excel 2003$b[electronic resource] $eprogramming with VBA /$fSteven M. Hansen 210 $aSan Francisco $cSYBEX$d2004 215 $a1 online resource (606 p.) 300 $aIncludes index. 311 $a0-7821-4281-8 327 $aContents; Introduction; Part 1 Introduction to Excel Development; Chapter 1 Excel as a Development Platform; Who Develops in Excel?; What Is an Excel Application?; Why Use Excel?; Stop When You See Red; Summary; Chapter 2 Getting to Know Your Environment; One Exceptional Editor; Managing Your Modules; Optimizing Your Editor; Helpful Editor Features; Understated Features of the Code Window; Object Inspection Using the Object Browser; Obtaining Help Has Never Been So Easy; Securing Your Project; Quick Code Navigation; Summary; Chapter 3 Getting Started with VBA; Thinking Like a Computer 327 $aVBA Building BlocksVariables Are the Elements You Interact With; Operators; Directing Your Program with Statements; Basic Array Usage; Objects-A Human-Friendly Way to Think of Bits and Bytes; Summary; Chapter 4 Debugging Tactics that Work; A Bug Epidemic; Debugging Weapons in the VBE; A Simple Debugging Methodology; Implementing Simple Error Handling; Summary; Part 2 Mastering the Excel Object Model; Chapter 5 Exploring the Application Object; A Bird's-Eye View of the Application Object; Display-Oriented Features You Have to Know; Display-Oriented Features That Are Nice to know 327 $aConvenient Excel Object PropertiesCommon File Operations Simplified; Inspecting Your Operating Environment; Two Useful Bonus Members; Summary; Chapter 6 Working with the Workbook Object; Walk before You Run: Opening and Closing Workbooks; Is That Workbook Open?; Untangle Links Programmatically (Part I); Plain Vanilla Workbook Properties; Respond to User Actions with Events; Summary; Chapter 7 Winning with Worksheets; Setting the Stage; Validating Your Worksheets before Using Them; Now You See It, Now You Don't; Lock Up Your Valuables; Managing Workbook Worksheets 327 $aExpounding on Worksheet EventsSummary; Chapter 8 The Most Important Object; Referring to Ranges; Finding My Way; Input Easy; Output Easier; Summary; Chapter 9 Practical Range Operations; Data Mobility with Cut, Copy, and Paste; Find What You Are Seeking; Don't Like It? Change It with Replace; Would You Like Special Sauce with That?; CurrentRegion: A Useful Shortcut; Sorting Lists Simplified; Summary; Chapter 10 Exploring Other Excel Objects; Make a Good First Impression; Chart Manipulation; Summary; Part 3 Advanced Excel Programming Techniques; Chapter 11 Developing Class Modules 327 $aClass Modules Are for Creating ObjectsA Linguistic Foundation; What's the Big Deal? Why Use Objects?; Creating a Simple Object; Using Your Object; A Better, Smarter Object; An Object Showdown; Collecting Your Objects; Implementing More Accurate Properties; Summary; Chapter 12 Adding User Personalization to Your Application; The Need for Persistence; Class Semi-Specification; Planning the Plumbing; Security Considerations; The Setting Class; Collect Those Setting Objects with Settings; Pseudo? Says Who?; Put Those Settings to Work; Summary; Chapter 13 Excel Development Best Practices 327 $aDeactivate Activate 330 $aCreate Powerful Business Applications with Excel 2003 Excel 2003 is an ideal application development platform for all levels of business needs. If you're an advanced Excel user looking to gain programming experience, or a skilled developer new to Excel or the Excel Object Model, this no-nonsense book teaches you how to build custom applications that can generate substantial time and cost savings for you, your employer, and your customers. Written by a professional with nearly a decade of experience producing Excel/VBA solutions, Mastering Excel 2003 Programming with VBA conve 606 $aBusiness$xComputer programs 606 $aElectronic spreadsheets 615 0$aBusiness$xComputer programs. 615 0$aElectronic spreadsheets. 676 $a005.369 676 $a005.54 700 $aHansen$b Steve$01486800 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910780447603321 996 $aMastering Excel 2003$93706411 997 $aUNINA