{"product_id":"excel-2016-power-programming-with-vba-isbn-9781119067726","title":"Excel 2016 Power Programming with VBA","description":"\u003cb\u003eMaximize your Excel experience with VBA\u003c\/b\u003e \u003cp\u003e\u003ci\u003eExcel 2016 Power Programming with VBA\u003c\/i\u003e is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. In addition to the procedures, tips, and ideas that will expand your capabilities, this resource provides you with access to over 100 online example Excel workbooks and the Power Utility Pak, found on the Mr. Spreadsheet website. \u003c\/p\u003e\u003cp\u003eUnderstanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce—and can help you take your career to the next level. \u003c\/p\u003e\u003cul\u003e \u003cli\u003eExplore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques\u003c\/li\u003e \u003cli\u003eLeverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text\u003c\/li\u003e \u003cli\u003eAccess online resources, including the Power Utility Pak, that supplement the content\u003c\/li\u003e \u003cli\u003eImprove your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eExcel 2016 Power Programming with VBA\u003c\/i\u003e is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA. \u003c\/p\u003e\u003cp\u003eIntroduction xxvii\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Introduction to Excel VBA\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Essentials of Spreadsheet Application Development 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is a Spreadsheet Application? 3\u003c\/p\u003e \u003cp\u003eSteps for Application Development 4\u003c\/p\u003e \u003cp\u003eDetermining User Needs 5\u003c\/p\u003e \u003cp\u003ePlanning an Application That Meets User Needs 6\u003c\/p\u003e \u003cp\u003eDetermining the Most Appropriate User Interface 8\u003c\/p\u003e \u003cp\u003eConcerning Yourself with the End User 12\u003c\/p\u003e \u003cp\u003eOther Development Issues 17\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Introducing Visual Basic for Applications 19\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGetting a Head Start with the Macro Recorder 19\u003c\/p\u003e \u003cp\u003eWorking with the Visual Basic Editor 32\u003c\/p\u003e \u003cp\u003eVBA Fundamentals 42\u003c\/p\u003e \u003cp\u003eDeep Dive: Working with Range Objects 47\u003c\/p\u003e \u003cp\u003eEssential Concepts to Remember 53\u003c\/p\u003e \u003cp\u003eDon’t Panic—You Are Not Alone55\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: VBA Programming Fundamentals 61\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eVBA Language Elements: An Overview 61\u003c\/p\u003e \u003cp\u003eComments 63\u003c\/p\u003e \u003cp\u003eVariables, Data Types, and Constants 64\u003c\/p\u003e \u003cp\u003eAssignment Statements 75\u003c\/p\u003e \u003cp\u003eArrays 77\u003c\/p\u003e \u003cp\u003eObject Variables79\u003c\/p\u003e \u003cp\u003eUser-Defined Data Types 80\u003c\/p\u003e \u003cp\u003eBuilt-In Functions 81\u003c\/p\u003e \u003cp\u003eManipulating Objects and Collections 84\u003c\/p\u003e \u003cp\u003eControlling Code Execution 87\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Working with VBA Sub Procedures 105\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAbout Procedures 105\u003c\/p\u003e \u003cp\u003eExecuting Sub Procedures 108\u003c\/p\u003e \u003cp\u003ePassing Arguments to Procedures 119\u003c\/p\u003e \u003cp\u003eError-Handling Techniques 123\u003c\/p\u003e \u003cp\u003eA Realistic Example That Uses Sub Procedures 127\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Creating Function Procedures 143\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSub Procedures versus Function Procedures 143\u003c\/p\u003e \u003cp\u003eWhy Create Custom Functions? 144\u003c\/p\u003e \u003cp\u003eAn Introductory Function Example 144\u003c\/p\u003e \u003cp\u003eFunction Procedures 148\u003c\/p\u003e \u003cp\u003eFunction Arguments 153\u003c\/p\u003e \u003cp\u003eFunction Examples 153\u003c\/p\u003e \u003cp\u003eEmulating Excel’s SUM Function 168\u003c\/p\u003e \u003cp\u003eExtended Date Functions 171\u003c\/p\u003e \u003cp\u003eDebugging Functions 173\u003c\/p\u003e \u003cp\u003eDealing with the Insert Function Dialog Box 174\u003c\/p\u003e \u003cp\u003eUsing Add-Ins to Store Custom Functions 178\u003c\/p\u003e \u003cp\u003eUsing the Windows API 179\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Understanding Excel’s Events 183\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat You Should Know about Events 183\u003c\/p\u003e \u003cp\u003eGetting Acquainted with Workbook-Level Events 190\u003c\/p\u003e \u003cp\u003eExamining Worksheet Events 197\u003c\/p\u003e \u003cp\u003eMonitoring with Application Events 206\u003c\/p\u003e \u003cp\u003eAccessing Events Not Associated with an Object 210\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7: VBA Programming Examples and Techniques 217\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLearning by Example 217\u003c\/p\u003e \u003cp\u003eWorking with Ranges 218\u003c\/p\u003e \u003cp\u003eWorking with Workbooks and Sheets 246\u003c\/p\u003e \u003cp\u003eVBA Techniques 251\u003c\/p\u003e \u003cp\u003eSome Useful Functions for Use in Your Code 259\u003c\/p\u003e \u003cp\u003eSome Useful Worksheet Functions 264\u003c\/p\u003e \u003cp\u003eWindows API Calls 280\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Advanced VBA Techniques\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8: Working with Pivot Tables 291\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAn Introductory Pivot Table Example 291\u003c\/p\u003e \u003cp\u003eCreating a More Complex Pivot Table 297\u003c\/p\u003e \u003cp\u003eCreating Multiple Pivot Tables 301\u003c\/p\u003e \u003cp\u003eCreating a Reverse Pivot Table 304\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9: Working with Charts 307\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGetting the Inside Scoop on Charts 307\u003c\/p\u003e \u003cp\u003eCreating an Embedded Chart 310\u003c\/p\u003e \u003cp\u003eCreating a Chart on a Chart Sheet 311\u003c\/p\u003e \u003cp\u003eModifying Charts 312\u003c\/p\u003e \u003cp\u003eUsing VBA to Activate a Chart 313\u003c\/p\u003e \u003cp\u003eMoving a Chart 314\u003c\/p\u003e \u003cp\u003eUsing VBA to Deactivate a Chart 315\u003c\/p\u003e \u003cp\u003eDetermining Whether a Chart Is Activated 316\u003c\/p\u003e \u003cp\u003eDeleting from the ChartObjects or Charts Collection 316\u003c\/p\u003e \u003cp\u003eLooping through All Charts 318\u003c\/p\u003e \u003cp\u003eSizing and Aligning ChartObjects 320\u003c\/p\u003e \u003cp\u003eCreating Lots of Charts 321\u003c\/p\u003e \u003cp\u003eExporting a Chart 324\u003c\/p\u003e \u003cp\u003eChanging the Data Used in a Chart 326\u003c\/p\u003e \u003cp\u003eUsing VBA to Display Arbitrary Data Labels on a Chart 331\u003c\/p\u003e \u003cp\u003eDisplaying a Chart in a UserForm 335\u003c\/p\u003e \u003cp\u003eUnderstanding Chart Events 337\u003c\/p\u003e \u003cp\u003eDiscovering VBA Charting Tricks 344\u003c\/p\u003e \u003cp\u003eWorking with Sparkline Charts 351\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10: Interacting with Other Applications 355\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Microsoft Office Automation 355\u003c\/p\u003e \u003cp\u003eAutomating Access from Excel 359\u003c\/p\u003e \u003cp\u003eAutomating Word from Excel 361\u003c\/p\u003e \u003cp\u003eAutomating PowerPoint from Excel 364\u003c\/p\u003e \u003cp\u003eAutomating Outlook from Excel 369\u003c\/p\u003e \u003cp\u003eStarting Other Applications from Excel 373\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11: Working with External Data and Files 379\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWorking with External Data Connections 379\u003c\/p\u003e \u003cp\u003eUsing ADO and VBA to Pull External Data 387\u003c\/p\u003e \u003cp\u003eWorking with Text Files 394\u003c\/p\u003e \u003cp\u003eText File Manipulation Examples 398\u003c\/p\u003e \u003cp\u003ePerforming Common File Operations 402\u003c\/p\u003e \u003cp\u003eZipping and Unzipping Files 410\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Working with UserForms\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12: Leveraging Custom Dialog Boxes 415\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBefore You Create That UserForm 415\u003c\/p\u003e \u003cp\u003eUsing an Input Box415\u003c\/p\u003e \u003cp\u003eThe VBA MsgBox Function 421\u003c\/p\u003e \u003cp\u003eThe Excel GetOpenFilename Method 426\u003c\/p\u003e \u003cp\u003eThe Excel GetSaveAsFilename Method 429\u003c\/p\u003e \u003cp\u003ePrompting for a Directory  430\u003c\/p\u003e \u003cp\u003eDisplaying Excel’s Built-In Dialog Boxes 430\u003c\/p\u003e \u003cp\u003eDisplaying a Data Form 433\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13: Introducing UserForms 435\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHow Excel Handles Custom Dialog Boxes 435\u003c\/p\u003e \u003cp\u003eInserting a New UserForm 436\u003c\/p\u003e \u003cp\u003eAdding Controls to a UserForm 437\u003c\/p\u003e \u003cp\u003eToolbox Controls  437\u003c\/p\u003e \u003cp\u003eAdjusting UserForm Controls 442\u003c\/p\u003e \u003cp\u003eAdjusting a Control’s Properties 443\u003c\/p\u003e \u003cp\u003eDisplaying a UserForm 449\u003c\/p\u003e \u003cp\u003eClosing a UserForm 451\u003c\/p\u003e \u003cp\u003eCreating a UserForm: An Example 453\u003c\/p\u003e \u003cp\u003eUnderstanding UserForm Events 459\u003c\/p\u003e \u003cp\u003eReferencing UserForm Controls 465\u003c\/p\u003e \u003cp\u003eCustomizing the Toolbox 466\u003c\/p\u003e \u003cp\u003eCreating UserForm Templates 469\u003c\/p\u003e \u003cp\u003eA UserForm Checklist 469\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14: UserForm Examples 471\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating a UserForm “Menu” 471\u003c\/p\u003e \u003cp\u003eSelecting Ranges from a UserForm  474\u003c\/p\u003e \u003cp\u003eCreating a Splash Screen 476\u003c\/p\u003e \u003cp\u003eDisabling a UserForm's Close Button 478\u003c\/p\u003e \u003cp\u003eChanging a UserForm's Size 479\u003c\/p\u003e \u003cp\u003eZooming and Scrolling a Sheet from a UserForm 480\u003c\/p\u003e \u003cp\u003eListBox Techniques 482\u003c\/p\u003e \u003cp\u003eUsing the MultiPage Control in a UserForm 503\u003c\/p\u003e \u003cp\u003eUsing an External Control 504\u003c\/p\u003e \u003cp\u003eAnimating a Label 506\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15: Advanced UserForm Techniques 511\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA Modeless Dialog Box 512\u003c\/p\u003e \u003cp\u003eDisplaying a Progress Indicator 516\u003c\/p\u003e \u003cp\u003eCreating Wizards 527\u003c\/p\u003e \u003cp\u003eEmulating the MsgBox Function 533\u003c\/p\u003e \u003cp\u003eA UserForm with Movable Controls 537\u003c\/p\u003e \u003cp\u003eA UserForm with No Title Bar 538\u003c\/p\u003e \u003cp\u003eSimulating a Toolbar with a UserForm 540\u003c\/p\u003e \u003cp\u003eEmulating a Task Pane with a UserForm 542\u003c\/p\u003e \u003cp\u003eA Resizable UserForm 543\u003c\/p\u003e \u003cp\u003eHandling Multiple UserForm Controls with One Event Handler 547\u003c\/p\u003e \u003cp\u003eSelecting a Color in a UserForm 550\u003c\/p\u003e \u003cp\u003eDisplaying a Chart in a UserForm 552\u003c\/p\u003e \u003cp\u003eMaking a UserForm Semitransparent 554\u003c\/p\u003e \u003cp\u003eA Puzzle on a UserForm 556\u003c\/p\u003e \u003cp\u003eVideo Poker on a UserForm 557\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Developing Excel Applications\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16: Creating and Using Add-Ins 561\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is an Add-In? 561\u003c\/p\u003e \u003cp\u003eUnderstanding Excel’s Add-In Manager 564\u003c\/p\u003e \u003cp\u003eCreating an Add-in 566\u003c\/p\u003e \u003cp\u003eAn Add-In Example 567\u003c\/p\u003e \u003cp\u003eComparing XLAM and XLSM Files 572\u003c\/p\u003e \u003cp\u003eManipulating Add-Ins with VBA 578\u003c\/p\u003e \u003cp\u003eOptimizing the Performance of Add-Ins 584\u003c\/p\u003e \u003cp\u003eSpecial Problems with Add-Ins 585\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17: Working with the Ribbon 589\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRibbon Basics 589\u003c\/p\u003e \u003cp\u003eCustomizing the Ribbon 591\u003c\/p\u003e \u003cp\u003eCreating a Custom Ribbon 596\u003c\/p\u003e \u003cp\u003eUsing VBA with the Ribbon 617\u003c\/p\u003e \u003cp\u003eCreating an Old-Style Toolbar 621\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18: Working with Shortcut Menus 625\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCommandBar Overview 625\u003c\/p\u003e \u003cp\u003eUsing VBA to Customize Shortcut Menus 632\u003c\/p\u003e \u003cp\u003eShortcut Menus and Events 642\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 19: Providing Help for Your Applications 647\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHelp for Your Excel Applications 647\u003c\/p\u003e \u003cp\u003eHelp Systems That Use Excel Components 649\u003c\/p\u003e \u003cp\u003eDisplaying Help in a Web Browser 657\u003c\/p\u003e \u003cp\u003eUsing the HTML Help System 659\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 20: Leveraging Class Modules 665\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is a Class Module? 665\u003c\/p\u003e \u003cp\u003eCreating a NumLock Class 667\u003c\/p\u003e \u003cp\u003eCoding Properties, Methods, and Events 671\u003c\/p\u003e \u003cp\u003eExposing a QueryTable Event 674\u003c\/p\u003e \u003cp\u003eCreating a Class to Hold Classes 677\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 21: Understanding Compatibility Issues 685\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is Compatibility? 685\u003c\/p\u003e \u003cp\u003eTypes of Compatibility Problems 686\u003c\/p\u003e \u003cp\u003eAvoid Using New Features 687\u003c\/p\u003e \u003cp\u003eBut Will It Work on a Mac? 689\u003c\/p\u003e \u003cp\u003eDealing with 64-Bit Excel 690\u003c\/p\u003e \u003cp\u003eCreating an International Application 691\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Appendix\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix A: VBA Statements and Function Reference 701\u003c\/p\u003e \u003cp\u003eIndex 709\u003c\/p\u003e   \u003cp\u003e\u003cb\u003eMichael Alexander\u003c\/b\u003e is a Microsoft Certified Application Developer and author of several books on Microsoft Access and Excel. He runs a free tutorial site at datapigtechnologies.com.  \u003c\/p\u003e\u003cp\u003e\u003cb\u003eDick Kusleika\u003c\/b\u003e has been helping users get the most out of Microsoft Office products for more than fifteen years through online forums, blogging, books, and conferences.  \u003c\/p\u003e\u003cp\u003e\u003cb\u003eJohn Walkenbach\u003c\/b\u003e is arguably the foremost authority on Excel. He has written more than 30 books and maintains the popular Spreadsheet Page at http:\/\/spreadsheetpage.com     \u003c\/p\u003e\u003cp\u003e\u003cb\u003e\u003ci\u003eBecome a power user with VBA\u003c\/i\u003e\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eTake your Excel skills to the next level by harnessing the power of the VBA language.  This comprehensive resource will help you automate data processes and develop full featured Excel programs.  Fully updated for the newest release of Excel, this one-of-a-kind resource presents everything you need to develop both large and small Excel applications.  \u003c\/p\u003e\u003cp\u003eThis book was designed with you in mind, giving you straight facts without hype or unnecessary explanations. This book offers tips, tricks and practical examples complete with all the code and sample templates you need to start your journey from humble data analyst to Excel programming pro.  \u003c\/p\u003e\u003cp\u003e\u003cb\u003e\u003ci\u003eLet Mr. Spreadsheet show you how to:\u003c\/i\u003e\u003c\/b\u003e  \u003c\/p\u003e\u003cul\u003e \u003cli\u003e\u003cb\u003eGo beyond recording simple macros\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eDynamically manipulate workbooks and worksheets\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eAutomate pivot table and chart features\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eManage external data and wrangle external files\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eSend emails directly from Excel\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eCreate your own Excel Ribbon interface\u003c\/b\u003e\u003c\/li\u003e \u003cli\u003e\u003cb\u003eDevelop and distribute your own Excel Add-ins\u003c\/b\u003e\u003c\/li\u003e \u003c\/ul\u003e  \u003cp\u003e\u003cb\u003eCOMPANION WEBSITE\u003c\/b\u003e\u003cbr\u003e Visit the companion website at www.wiley.com\/go\/excel2016powerprogramming to find files used as examples in the book\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989181743333,"sku":"NP9781119067726","price":54.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119067726.jpg?v=1761783115","url":"https:\/\/k12savings.com\/products\/excel-2016-power-programming-with-vba-isbn-9781119067726","provider":"K12savings","version":"1.0","type":"link"}