05616nam 2200733 a 450 991081417250332120230105192843.01-118-49040-11-118-49180-7(CKB)2670000000341484(EBL)1144767(OCoLC)831119167(SSID)ssj0000906980(PQKBManifestationID)11496073(PQKBTitleCode)TC0000906980(PQKBWorkID)10856043(PQKB)10932075(OCoLC)847729041(Au-PeEL)EBL1144767(CaPaEBR)ebr10674764(CaONFJC)MIL531259(CaSebORM)9781118490402(MiAaPQ)EBC1144767(OCoLC)877823240(OCoLC)ocn877823240(EXLCZ)99267000000034148420130419d2013 uy 0engur|n|---|||||txtccrExcel 2013 power programming with VBA /by John Walkenbach1st editionHoboken, N.J. Wileyc20131 online resource (1107 p.)Mr. Spreadsheet's BookshelfIncludes index.1-118-49039-8 Microsoft® 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 FeaturesAnalysis 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 FilesExcel 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 ExplorerWorking 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 ProceduresAbout 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 TechniquesLearning by ExampleMaximize 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 fMr. Spreadsheet's bookshelf.Microsoft Excel 2013 power programming with VBAExcel power programming with VBABusinessComputer programsElectronic spreadsheetsElectronic spreadsheetsComputer programsBusinessComputer programs.Electronic spreadsheets.Electronic spreadsheetsComputer programs.650.02855365Walkenbach John61459MiAaPQMiAaPQMiAaPQBOOK9910814172503321Excel 2013 power programming with VBA4050291UNINA