05064nam 2200613Ia 450 991045988070332120200520144314.01-282-77371-297866127737160-470-92263-X(CKB)2670000000043948(EBL)588929(OCoLC)813232464(SSID)ssj0000404531(PQKBManifestationID)11302579(PQKBTitleCode)TC0000404531(PQKBWorkID)10364509(PQKB)11004278(MiAaPQ)EBC588929(CaSebORM)9780470634004(Au-PeEL)EBL588929(CaPaEBR)ebr10412498(CaONFJC)MIL277371(EXLCZ)99267000000004394820100521d2010 uy 0engur|n|---|||||txtccrMastering VBA for Office 2010[electronic resource] /Richard Mansfield1st ed.Indianapolis, IN Wiley Publishing, Inc.20101 online resource (915 p.)Sybex serious skillsIncludes index.0-470-63400-6 MASTERING VBA for Microsoft® Office 2010; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; Where to Get the Example Code; What Can I Do with VBA?; What's in This Book?; How Should I Use This Book?; Is This Book Suitable for Me?; Conventions Used in This Book; Part 1: Recording Macros and Getting Started with VBA; Chapter 1: Recording and Running Macros in the Office Applications; What Is VBA and What Can You Do with It?; Understanding Macro Basics; Recording a Macro; Running a Macro; Recording a Sample Word Macro; Recording a Sample Excel MacroAssigning a Way of Running the MacroDeleting a Macro; The Bottom Line; Chapter 2: Getting Started with the Visual Basic Editor; Opening the Visual Basic Editor; Using the Visual Basic Editor's Main Windows; Setting Properties for a Project; Customizing the Visual Basic Editor; Closing the Visual Basic Editor and Returning to the Host Application; The Bottom Line; Chapter 3: Editing Recorded Macros; Testing a Macro in the Visual Basic Editor; Editing the Word Macro; Editing the Excel Macro; Editing a PowerPoint Macro; The Bottom LineChapter 4: Creating Code from Scratch in the Visual Basic EditorSetting Up the Visual Basic Editor for Creating the Procedures; Creating a Procedure for Word; Creating a Procedure for Excel; Creating a Procedure for PowerPoint; Creating a Procedure for Access; The Bottom Line; Part 2: Learning How to Work with VBA; Chapter 5: Understanding the Essentials of VBA Syntax; Getting Ready; Procedures; Statements; Keywords; Expressions; Operators; Variables; Constants; Arguments; Objects; Collections; Properties; Methods; Events; The Bottom LineChapter 6: Working with Variables, Constants, and EnumerationsWorking with Variables; Working with Constants; Working with Enumerations; The Bottom Line; Chapter 7: Using Array Variables; What Is an Array?; Declaring an Array; Storing Values in an Array; Multidimensional Arrays; Declaring a Dynamic Array; Redimensioning an Array; Returning Information from an Array; Erasing an Array; Finding Out Whether a Variable Is an Array; Finding the Bounds of an Array; Sorting an Array; Searching through an Array; The Bottom Line; Chapter 8: Finding the Objects, Methods, and Properties You NeedWhat Is an Object?Working with Collections; Finding the Objects You Need; Using Object Variables to Represent Objects; The Bottom Line; Part 3: Making Decisions and Using Loops and Functions; Chapter 9: Using Built-in Functions; What Is a Function?; Using Functions; Using Functions to Convert Data from One Type to Another; Using Functions to Manipulate Strings; Using VBA's Mathematical Functions; Using VBA's Date and Time Functions; Using File-Management Functions; The Bottom Line; Chapter 10: Creating Your Own Functions; Components of a Function; Creating a FunctionExamples of Functions for Any VBA-Enabled ApplicationA comprehensive guide to the language used to customize Microsoft Office Visual Basic for Applications (VBA) is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master VBA in order to customize the entire Office suite for specific business needs.Office 2010 is the leading productivity suite, and the VBA language enables customizations of all the Office programs; this complete guide gives both novice Electronic books.005.2/768Mansfield Richard1945-811371MiAaPQMiAaPQMiAaPQBOOK9910459880703321Mastering VBA for Office 20101948827UNINA