LEADER 05258nam 2200625 a 450 001 9910144136703321 005 20170815112603.0 010 $a1-281-73243-5 010 $a9786611732431 010 $a1-118-25759-6 010 $a0-470-15130-7 035 $a(CKB)1000000000537155 035 $a(EBL)353547 035 $a(OCoLC)243599932 035 $a(SSID)ssj0000074842 035 $a(PQKBManifestationID)11107747 035 $a(PQKBTitleCode)TC0000074842 035 $a(PQKBWorkID)10122511 035 $a(PQKB)11701049 035 $a(MiAaPQ)EBC353547 035 $a(CaSebORM)9780470044018 035 $a(EXLCZ)991000000000537155 100 $a20061201d2007 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExcel 2007 power programming with VBA$b[electronic resource] /$fby John Walkenbach 205 $a1st edition 210 $aHoboken, N.J. $cWiley ;$a[Chichester $cJohn Wiley, distributor]$dc2007 215 $a1 online resource (1106 p.) 225 1 $aMr. Spreadsheet's bookshelf 300 $aIncludes index. 311 $a0-470-04401-2 327 $aExcel 2007 Power Programming with VBA; About the Author; Preface; Topics Covered; What You Need to Know; What You Need to Have; Conventions in This Book; What the Icons Mean; How This Book Is Organized; About the Companion CD-ROM; About the Power Utility Pak Offer; How to Use This Book; Reach Out; Contents at a Glance; Table of Contents; Part I: Some Essential Background; Chapter 1: Excel 2007: Where It Came From; A Brief History of Spreadsheets; Why Excel Is Great for Developers; Excel's Role in Microsoft's Strategy; Chapter 2: Excel in a Nutshell; Thinking in Terms of Objects; Workbooks 327 $aExcel's User InterfaceCustomizing the Display; Data Entry; Formulas, Functions, and Names; Selecting Objects; Formatting; Protection Options; Charts; Shapes and SmartArt; Database Access; Internet Features; Analysis Tools; Add-Ins; Macros and Programming; File Format; Excel's Help System; Chapter 3: Formula Tricks and Techniques; About Formulas; Calculating Formulas; Cell and Range References; Using Names; Formula Errors; Array Formulas; Counting and Summing Techniques; Working with Dates and Times; Creating Megaformulas; Chapter 4: Understanding Excel's Files; Starting Excel; File Types 327 $aWorking with Template FilesInside an Excel File; The QAT File; The XLB File; Add-In Files; Excel Settings in the Registry; Part II: Excel Application Development; Chapter 5: What Is a Spreadsheet Application?; Spreadsheet Applications; The Developer and the End User; Solving Problems with Excel; Basic Spreadsheet Types; Chapter 6: Essentials of Spreadsheet Application Development; Determining User Needs; Planning an Application That Meets User Needs; Determining the Most Appropriate User Interface; Concerning Yourself with the End User; Other Development Issues 327 $aPart III: Understanding Visual Basic for ApplicationsChapter 7: Introducing Visual Basic for Applications; Some BASIC Background; About VBA; The Basics of VBA; Introducing the Visual Basic Editor; Working with the Project Explorer; Working with Code Windows; Customizing the VBE Environment; The Macro Recorder; About Objects and Collections; Properties and Methods; The Comment Object: A Case Study; Some Useful Application Properties; Working with Range Objects; Things to Know about Objects; Chapter 8: VBA Programming Fundamentals; VBA Language Elements: An Overview; Comments 327 $aVariables, Data Types, and ConstantsAssignment Statements; Arrays; Object Variables; User-Defined Data Types; Built-in Functions; Manipulating Objects and Collections; Controlling Code Execution; Chapter 9: Working with VBA Sub Procedures; About Procedures; Executing Sub Procedures; Passing Arguments to Procedures; Error-Handling Techniques; A Realistic Example That Uses Sub Procedures; Chapter 10: Creating Function Procedures; Sub Procedures versus Function Procedures; Why Create Custom Functions?; An Introductory Function Example; Function Procedures; Function Arguments; Function Examples 327 $aEmulating Excel's SUM Function 330 $aThis book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhereFully 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 elseJohn Walkenbach, aka ""Mr. Spreadsheet,"" is one of the world's leading authorities on ExcelThoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded coll 410 0$aMr. Spreadsheet's bookshelf. 606 $aVisual programming (Computer science) 608 $aElectronic books. 615 0$aVisual programming (Computer science) 676 $a005.54 700 $aWalkenbach$b John$061459 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910144136703321 996 $aExcel 2007 power programming with VBA$92275742 997 $aUNINA