- Häftad (Paperback / softback)
- Antal sidor
- John Wiley & Sons Inc
- Kusleika, Dick
- 234 x 190 x 44 mm
- Antal komponenter
- 997 g
Du kanske gillar
Excel 2016 Power Programming with VBA479Skickas inom 7-10 vardagar.
Gratis frakt inom Sverige över 159 kr för privatpersoner.Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA 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. Understanding 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. * Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques * Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text * Access online resources, including the Power Utility Pak, that supplement the content * Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office Excel 2016 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.
KundrecensionerHar du läst boken? Sätt ditt betyg »
Michael Alexander 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. Dick Kusleika has been helping users get the most out of Microsoft Office products for more than fifteen years through online forums, blogging, books, and conferences. John Walkenbach is arguably the foremost authority on Excel. He has written more than 30 books and maintains the popular Spreadsheet Page at http://spreadsheetpage.com
Introduction xxvii Part I: Introduction to Excel VBA Chapter 1: Essentials of Spreadsheet Application Development 3 What Is a Spreadsheet Application? 3 Steps for Application Development 4 Determining User Needs 5 Planning an Application That Meets User Needs 6 Determining the Most Appropriate User Interface 8 Customizing the Ribbon 8 Customizing shortcut menus 8 Creating shortcut keys 9 Creating custom dialog boxes 9 Using ActiveX controls on a worksheet 10 Executing the development effort 11 Concerning Yourself with the End User 12 Testing the application 12 Making the application bulletproof 13 Making the application aesthetically appealing and intuitive 15 Creating a user Help system 16 Documenting the development effort 16 Distributing the application to the user 16 Updating the application when necessary 17 Other Development Issues 17 The user s installed version of Excel 17 Language issues 17 System speed 18 Video modes 18 Chapter 2: Introducing Visual Basic for Applications 19 Getting a Head Start with the Macro Recorder 19 Creating your first macro 20 Comparing absolute and relative macro recording 23 Other macro recording concepts 27 Working with the Visual Basic Editor 32 Understanding VBE components 32 Working with the Project window 33 Working with a Code window 36 Customizing the VBA environment 38 The Editor Format tab 40 The General tab 41 The Docking tab 41 VBA Fundamentals 42 Understanding objects 43 Understanding collections 43 Understanding properties 44 Deep Dive: Working with Range Objects 47 Finding the properties of the Range object 48 The Range property 48 The Cells property 49 The Offset property 52 Essential Concepts to Remember 53 Don t Panic You Are Not Alone 55 Read the rest of the book 55 Let Excel help write your macro 55 Use the Help system 55 Use the Object Browser 56 Pilfer code from the Internet 57 Leverage user forums 57 Visit expert blogs 58 Mine YouTube for video training 58 Learn from the Microsoft Office Dev Center 59 Dissect the other Excel files in your organization 59 Ask your local Excel genius 59 Chapter 3: VBA Programming Fundamentals 61 VBA Language Elements: An Overview 61 Comments 63 Variables, Data Types, and Constants 64 Defining data types 65 Declaring variables 67 Scoping variables 69 Working with constants 72 Working with strings 73 Working with dates 74 Assignment Statements 75 Arrays 77 Declaring arrays 77 Declaring multidimensional arrays 78 Declaring dynamic arrays 79 Object Variables 79 User-Defined Data Types 80 Built-In Functions 81 Manipulating Objects and Collections 84 With-End With constructs 84 For Each-Next constructs 85 Controlling Code Execution 87 GoTo statements 88 If-Then constructs 88 Select Case constructs 93 Looping blocks of instructions 96 Chapter 4: Working with VBA Sub Procedures 105 About Procedures 105 Declaring a Sub procedure 106 Scoping a procedure 107 Executing Sub Procedures 108 Executing a procedure with the Run Sub/UserForm command 109 Executing a procedure from the Macro dialog box 109 Executing a procedure with a Ctrl+shortcut key combination 110 Executing a procedure from the Ribbon 111 Executing a procedure from a customized shortcut menu 111 Executing a procedure from another procedure 112 Executing a procedure by clicking an object 116 Executing a procedure when an event occurs 118 Executing a procedure from the Immediate window 118 Passing Arguments to Procedures 119 Error-Handling Techniques 123 Trapping errors 123 Error-handling examples 124 A Realistic Example That Uses Sub Procedures 127 The goal 128 Project requirements 128 What you know 128 The approach 129 Some preliminary recording 129 Init