LEADER 05496nam 2200697 a 450 001 9910462904903321 005 20200520144314.0 010 $a1-118-49040-1 010 $a1-118-49180-7 035 $a(CKB)2670000000341484 035 $a(EBL)1144767 035 $a(OCoLC)831119167 035 $a(SSID)ssj0000906980 035 $a(PQKBManifestationID)11496073 035 $a(PQKBTitleCode)TC0000906980 035 $a(PQKBWorkID)10856043 035 $a(PQKB)10932075 035 $a(OCoLC)847729041 035 $a(MiAaPQ)EBC1144767 035 $a(CaSebORM)9781118490402 035 $a(Au-PeEL)EBL1144767 035 $a(CaPaEBR)ebr10674764 035 $a(CaONFJC)MIL531259 035 $a(EXLCZ)992670000000341484 100 $a20130419d2013 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExcel 2013 power programming with VBA$b[electronic resource] /$fby John Walkenbach 205 $a1st edition 210 $aHoboken, N.J. $cWiley$dc2013 215 $a1 online resource (1107 p.) 225 1 $aMr. Spreadsheet's Bookshelf 300 $aIncludes index. 311 $a1-118-49039-8 327 $aMicrosoft® Excel® 2013 Power Programming with VBA; Introduction; 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 This Book's Website; About the Power Utility Pak Offer; How to Use This Book; Part 1: Some Essential Background; Chapter 1: Excel in a Nutshell; About Excel; Thinking in Terms of Objects; Workbooks; Excel's User Interface; Data Entry; Formulas, Functions, and Names; Selecting Objects; Formatting; Protection Options; Charts; Shapes and SmartArt; Database Access; Internet Features 327 $aAnalysis ToolsAdd-Ins; Macros and Programming; File Format; Excel's Help System; Chapter 2: Formula Tricks and Techniques; About Formulas; Calculating Formulas; Cell and Range References; Using Names; Formula Errors; Excel Auditing Tools; Array Formulas; Counting and Summing Techniques; Lookup Formulas; Working with Dates and Times; Creating Megaformulas; Chapter 3: Understanding Excel Files; Starting Excel; File Types; Excel File Compatibility; Protected View; Using AutoRecover; Working with Template Files; Inside an Excel File; The OfficeUI File; The XLB File; Add-In Files 327 $aExcel Settings in the RegistryChapter 4: Essentials of Spreadsheet Application Development; What Is a Spreadsheet Application?; Steps for 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; Part 2: Understanding Visual Basic for Applications; Chapter 5: Introducing Visual Basic for Applications; Getting Some BASIC Background; Delving into VBA; Covering the Basics of VBA; Introducing Visual Basic Editor; Working with Project Explorer 327 $aWorking with Code WindowsCustomizing 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 6: VBA Programming Fundamentals; VBA Language Elements: An Overview; Comments; Variables, Data Types, and Constants; Assignment Statements; Arrays; Object Variables; User-Defined Data Types; Built-in Functions; Manipulating Objects and Collections; Controlling Code Execution; Chapter 7: Working with VBA Sub Procedures 327 $aAbout ProceduresExecuting Sub Procedures; Passing Arguments to Procedures; Error-Handling Techniques; A Realistic Example That Uses Sub Procedures; Chapter 8: Creating Function Procedures; Sub Procedures versus Function Procedures; Why Create Custom Functions?; An Introductory Function Example; Function Procedures; Function Arguments; Function Examples; Emulating Excel's SUM function; Extended Date Functions; Debugging Functions; Dealing with the Insert Function Dialog Box; Using Add-ins to Store Custom Functions; Using the Windows API; Chapter 9: VBA Programming Examples and Techniques 327 $aLearning by Example 330 $a Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, ""Mr. Spreadsheet"" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic f 410 0$aMr. Spreadsheet's bookshelf. 606 $aBusiness$xComputer programs 606 $aElectronic spreadsheets 606 $aElectronic spreadsheets$xComputer programs 608 $aElectronic books. 615 0$aBusiness$xComputer programs. 615 0$aElectronic spreadsheets. 615 0$aElectronic spreadsheets$xComputer programs. 676 $a650.02855365 700 $aWalkenbach$b John$061459 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910462904903321 996 $aExcel 2013 power programming with VBA$92237308 997 $aUNINA