| Contents Notes |
Part one. Recording macros and getting Started with VBA. 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 macro -- Specifying how to trigger an existing macro -- Deleting a macro) -- Getting started with the Visual Basic Editor -- (Opening Visual Basic Editor -- Using the Visual Basic Editor's main window -- Setting properties for a project -- Customizing the Visual Basic Editor) -- Editing recorded macros -- (Testing a macro in the Visual Basic Editor -- Editing a Word macro -- Editing the Excel macro -- Editing a PowerPoint macro) -- Creating code from scratch in the Visual Basic Editor -- (Setting up the Visual Basic Editor to create macros -- Creating a procedure for Word -- Creating a macro for Excel -- Creating a procedure for PowerPoint -- Creating a procedure for Access). Part two. Learning how to work with VBA. Understanding the essentials of VBA syntax -- (Getting ready -- Procedures -- Statements -- Keywords -- Expressions -- Operators -- Variables -- Constants -- Arguments -- Objects -- Collection -- Properties -- Methods -- Events) -- Working with variables, constants, and enumerations -- Using array variables -- (What is an array? -- Declaring an array -- Storing values in an array -- Declaring a dynamic array -- Redimensioning an array -- Returning information from an array -- Erasing an array -- Determining whether a variable is an array -- Finding the bounds of an array -- Sorting an array -- Searching an array) -- Finding the objects, methods, and properties you need -- (What is an object -- Working with collections -- Finding the objects you need -- Using object variables to represent objects -- Team programming and OOP). Part three. Making decisions and using loops and functions. Using built-in functions -- (Using functions to convert data -- Using the Asc function to return a character code -- Using the Val function to extract a number from the start of a string -- Using the format function to format an expression -- Using the Chr function and constants to enter special characters in a string -- Using functions to manipulate strings -- Using the Left, Right, and Mid functions to return part of a string -- Using InStr and InStrRev to find a string within another string -- Using LTrim, RTrim, and Trim to remove spaces from a string -- Using Len to check the length of a string -- Using StrConv, LCase, and UCase to change the case of a string -- Using the StrComp function to compare apples to apples -- Using VBA's mathematical functions -- Using VBA's date and time functions -- Using the DatePart function to parse dates -- Calculating timeintervals using the DateDiff function -- Using the DateAdd function to add or subtract time from a date -- Using file-management functions -- Checking whether a file exists using the Dir function) -- Creating your own functions -- (Components of a function -- Creating a function -- Examples of functions for any VBA-enabled Office application -- Creating a function: For Word ; For Excel ; For PowerPoint ; For Access) -- Making decisions in your code -- (How do you compare things in VBA -- Testing multiple conditions by using logical operators -- Select case blocks) -- Using loops to repeat actions -- (When should you use a loop? -- Understanding the basics of loops --- Using For...loops for fixed repetitions -- Using Do...loops for variable numbers of repetitions -- While...Wend loops -- Nesting loops -- Avoiding loops). Part four. Using message boxes, input boxes, and dialog boxes. Getting user input with message boxes and input boxes -- (Opening a macro -- Displaying status-bar messages in Word and Excel -- Message boxes -- Input boxes -- Forms: when message boxes and input boxes won't suffice) -- Creating simple custom dialog boxes -- (When should you use a custom dialog box? -- Creating a custom dialog box -- Working with groups of controls -- Linking a form to a procedure -- Retrieving the user's choices from a dialog box -- Examples of connecting forms to procedures -- Using an application's built-in dialog boxes from VBA) -- Creating complex forms -- (Creating and working with complex dialog boxes -- Using events to control forms). Part five. Creating effective code. Building modular code and using classes -- Debugging your code and handling errors -- (Principles of debugging -- The different types of errors -- VBA's debugging tools -- Dealing with loops -- Dealing with runtime errors -- Suppressing alerts -- Handling user interrupts in Word, Excel, and project -- Documenting your code) -- Building well-behaved code -- (What is a well-behaved procedure -- Retaining or restoring the user environment -- Leaving the user in the best position to continue working -- Keeping the user informed during the procedure -- Making sure a procedure is running under suitable conditions -- Cleaning up after a procedure) -- Exploring VBA's security features -- (Understanding how VBA implements security -- Signing your macro projects with digital signatures -- Choosing a suitable level of security --Locking your code). Part six. Programming the Office applications. Understanding the Word object model and key objects -- (Examining the Word object model -- Working with the Documents collection and the Document object -- Printing a document -- Working with the ActiveDocument object -- Working with the Selection object -- Creating and using ranges -- Manipulating options) -- Working with widely used objects in Word -- (Using Find and Replace via VBA -- Working with headers, footers, and page numbers -- Working with sections, page setup, windows, and views -- Working with tables) -- Understanding the Excel object model and key objects -- (Getting an overview of the Excel object model -- Understanding Excel's creatable objects -- Managing workbooks -- Working with worksheets -- Working with the active cell or selection -- Working with ranges -- Setting options) -- Working with widely used objects in Excel -- (Working with charts -- Working with Window objects -- Working with Find and Replace -- Adding shapes) -- Understanding the PowerPoint object model and key objects -- (Overview -- Understanding PowerPoint's creatable objects -- Working with presentations -- Working with windows and views -- Working with slides -- Working with masters) -- Working with shapes and running slide shows -- Understanding the Outlook object model and key objects -- (Working with Application object -- Understanding general methods for working with Outlook objects -- Working with messages -- Working with calendar items -- Working with tasks and task requests -- Searching for items) -- Working with events in Outlook -- (Working with application-level events -- Working with item-level events -- Understanding Quick Steps) -- Understanding the Access object model and key objects -- (Getting started with VBA in Access -- Getting an overview of the Access object model -- Understanding creatable objects in Access -- Opening and closing databases -- Working with the Screen object) -- Manipulating the data in an access database in VBA -- (Understanding how to proceed -- Preparing to manage the data in a database -- Opening a recordset -- Accessing a particular record in a recordset -- Searching for a record -- Returning the fields in a record -- Editing a record -- Inserting and deleting records -- Closing a recordset -- Saving a recordset to the cloud) -- Accessing one application from another application -- (Understanding the tools used to communicate between applications -- Using automation to transfer information -- Using the Shell function to run an application -- Using data objects to store and retrieve information -- Communicating via DDE -- Communicating via SendKeys -- Going beyond VBA) -- Programming the Office 2016 ribbon -- (Hiding the Clipboard group on the Word Ribbon -- Working with Excel and PowerPoint -- Undoing Ribbon modifications -- Selecting the scope of your Ribbon customization -- Adding a new group -- Adding callbacks -- Adding attributes -- Using menus and lists -- Toggling with a toggle-button control -- Modifying the Ribbon in Access -- Adding a callback in Access -- What to look for if things go wrong -- Where to go from here). Shows how to extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even with no programming experience, users will be able to learn automating routine computing processes quickly using VBA programming language. Tutorials walk beginners through the basics, while intermediate and advanced content guides more experienced users toward efficient solutions. This guide starts at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language as you use loops and functions, message boxes, input boxes, and dialog boxes to design your own Office automation program. Add-ins, embedded macros, content controls, and more give you advanced tools to enhance productivity, and all instruction is backed by real-world practice projects in Word, Excel, Outlook, and PowerPoint. This book shows you how, with step-by-step guidance, to: expand Office 2016 functionality with macros ; learn how to work with VBA and the entire Office suite ; create effective code, even with no programing experience ; understand ActiveX, XML-based files, the developer tab, and more. --Adapted from publisher description. |
