Mastering VBA for Microsoft Office 2013.

By: Mansfield, RichardPublisher: Somerset : John Wiley & Sons, Incorporated, 2013Copyright date: ©2013Edition: 2nd edDescription: 1 online resource (1306 pages)Content type: text Media type: computer Carrier type: online resourceISBN: 9781118750223Subject(s): Microsoft Visual Basic for applications.;Microsoft Office.;Business -- Computer programsGenre/Form: Electronic books. Additional physical formats: Print version:: Mastering VBA for Microsoft Office 2013DDC classification: 005.36 LOC classification: QA76.73.M53 -- M36 2013ebOnline resources: Click to View
Contents:
Cover -- Acknowledgments -- About the Author -- Introduction -- 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 Macro -- Specifying How to Trigger an Existing Macro -- Deleting 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 -- 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 Line -- Chapter 4: Creating Code from Scratch in the Visual Basic Editor -- Setting 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 Line -- Chapter 6: Working with Variables, Constants, and Enumerations -- Working 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 Need -- What Is an Object? -- Working with Collections -- Finding the Objects You Need -- Using Object Variables to Represent Objects -- Team Programming and OOP -- 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 -- 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 Function -- Examples of Functions for Any VBA-Enabled Office Application -- Creating a Function for Word -- Creating a Function for Excel -- Creating a Function for PowerPoint -- Creating a Function for Access -- The Bottom Line -- Chapter 11: Making Decisions in Your Code -- How Do You Compare Things in VBA? -- Testing Multiple Conditions by Using Logical Operators -- Select Case Blocks -- The Bottom Line -- Chapter 12: 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 Infinite Loops -- The Bottom Line -- Part 4: Using Message Boxes, Input Boxes, and Dialog Boxes -- Chapter 13: Getting User Input with Message Boxes and Input Boxes -- Opening a Procedure to Work On -- Displaying Status-Bar Messages in Word and Excel -- Message Boxes -- Input Boxes -- Forms: When Message Boxes and Input Boxes Won't Suffice -- The Bottom Line.
Chapter 14: Creating Simple Custom Dialog Boxes -- When Should You Use a Custom Dialog Box? -- Creating a Custom Dialog Box -- 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 -- The Bottom Line -- Chapter 15: Creating Complex Forms -- Creating and Working with Complex Dialog Boxes -- Using Events to Control Forms -- The Bottom Line -- Part 5: Building Modular Code and Using Classes -- Chapter 16: Building Modular Code and Using Classes -- Creating Modular Code -- Creating and Using Classes -- The Bottom Line -- Chapter 17: Debugging Your Code and Handling Errors -- Principles of Debugging -- The Different Types of Errors -- VBA's Debugging Tools -- Dealing with Infinite Loops -- Dealing with Runtime Errors -- Suppressing Alerts -- Handling User Interrupts in Word, Excel, and Project -- Documenting Your Code -- The Bottom Line -- Chapter 18: 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 -- The Bottom Line -- Chapter 19: Securing Your Code with 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 -- The Bottom Line -- Part 6: Programming the Office Applications -- Chapter 20: Understanding the Word Object Model and Key Objects -- Examining the Word Object Model -- Working with the Documents Collection and the Document Object -- Working with the Selection Object -- Creating and Using Ranges -- Manipulating Options.
The Bottom Line -- Chapter 21: 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 -- The Bottom Line -- Chapter 22: 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 -- The Bottom Line -- Chapter 23: Working with Widely Used Objects in Excel -- Working with Charts -- Working with Windows -- Working with Find and Replace -- Adding Shapes -- The Bottom Line -- Chapter 24: Understanding the PowerPoint Object Model and Key Objects -- Getting an Overview of the PowerPoint Object Model -- Understanding PowerPoint's Creatable Objects -- Working with Presentations -- Working with Windows and Views -- Working with Slides -- Working with Masters -- The Bottom Line -- Chapter 25: Working with Shapes and Running Slide Shows -- Working with Shapes -- Working with Headers and Footers -- Setting Up and Running a Slide Show -- The Bottom Line -- Chapter 26: Understanding the Outlook Object Model and Key Objects -- Getting an Overview of the Outlook Object Model -- Working with the 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 -- The Bottom Line -- Chapter 27: Working with Events in Outlook -- Working with Application-Level Events -- Working with Item-Level Events -- Understanding Quick Steps -- The Bottom Line -- Chapter 28: 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 -- Using the DoCmd Object to Run Access Commands -- The Bottom Line -- Chapter 29: Manipulating the Data in an Access Database via 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 -- The Bottom Line -- Chapter 30: 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 -- The Bottom Line -- Chapter 31: Programming the Office 2013 Ribbon -- What Is XML? -- Hiding the Editing 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 -- The Bottom Line -- Appendix: The Bottom Line -- Chapter 1: Recording and Running Macros in the Office Applications -- Chapter 2: Getting Started with the Visual Basic Editor -- Chapter 3: Editing Recorded Macros -- Chapter 4: Creating Code from Scratch in the Visual Basic Editor -- Chapter 5: Understanding the Essentials of VBA Syntax.
Chapter 6: Working with Variables, Constants, and Enumerations.
Summary: A unique, comprehensive guide to creating custom apps with VBA Automating computing tasks to increase productivity is a goal for businesses of all sizes. Visual Basic for Applications (VBA) is a version of Visual Basic designed to be easily understandable for novice programmers, but still powerful enough for IT professionals who need to create specialized business applications. With this invaluable book, you'll learn how to extend the capabilities of Office 2013 applications with VBA programming and use it for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. Covers the basics of VBA in clear, systematic tutorials and includes intermediate and advanced content for experienced VB developers Explores recording macros and getting started with VBA; learning how to work with VBA; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files, ActiveX, the developer tab, content controls, add-ins, embedded macros, and security Anchors the content with solid, real-world projects in Word, Excel, Outlook, PowerPoint, and Access Covering VBA for the entire suite of Office 2013 applications, Mastering VBA for Microsoft Office 2013 is mandatory reading.
Holdings
Item type Current library Call number Status Date due Barcode Item holds
Ebrary Ebrary Afghanistan
Available EBKAF00086096
Ebrary Ebrary Algeria
Available
Ebrary Ebrary Cyprus
Available
Ebrary Ebrary Egypt
Available
Ebrary Ebrary Libya
Available
Ebrary Ebrary Morocco
Available
Ebrary Ebrary Nepal
Available EBKNP00086096
Ebrary Ebrary Sudan

Access a wide range of magazines and books using Pressreader and Ebook central.

Enjoy your reading, British Council Sudan.

Available
Ebrary Ebrary Tunisia
Available
Total holds: 0

Cover -- Acknowledgments -- About the Author -- Introduction -- 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 Macro -- Specifying How to Trigger an Existing Macro -- Deleting 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 -- 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 Line -- Chapter 4: Creating Code from Scratch in the Visual Basic Editor -- Setting 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 Line -- Chapter 6: Working with Variables, Constants, and Enumerations -- Working 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 Need -- What Is an Object? -- Working with Collections -- Finding the Objects You Need -- Using Object Variables to Represent Objects -- Team Programming and OOP -- 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 -- 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 Function -- Examples of Functions for Any VBA-Enabled Office Application -- Creating a Function for Word -- Creating a Function for Excel -- Creating a Function for PowerPoint -- Creating a Function for Access -- The Bottom Line -- Chapter 11: Making Decisions in Your Code -- How Do You Compare Things in VBA? -- Testing Multiple Conditions by Using Logical Operators -- Select Case Blocks -- The Bottom Line -- Chapter 12: 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 Infinite Loops -- The Bottom Line -- Part 4: Using Message Boxes, Input Boxes, and Dialog Boxes -- Chapter 13: Getting User Input with Message Boxes and Input Boxes -- Opening a Procedure to Work On -- Displaying Status-Bar Messages in Word and Excel -- Message Boxes -- Input Boxes -- Forms: When Message Boxes and Input Boxes Won't Suffice -- The Bottom Line.

Chapter 14: Creating Simple Custom Dialog Boxes -- When Should You Use a Custom Dialog Box? -- Creating a Custom Dialog Box -- 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 -- The Bottom Line -- Chapter 15: Creating Complex Forms -- Creating and Working with Complex Dialog Boxes -- Using Events to Control Forms -- The Bottom Line -- Part 5: Building Modular Code and Using Classes -- Chapter 16: Building Modular Code and Using Classes -- Creating Modular Code -- Creating and Using Classes -- The Bottom Line -- Chapter 17: Debugging Your Code and Handling Errors -- Principles of Debugging -- The Different Types of Errors -- VBA's Debugging Tools -- Dealing with Infinite Loops -- Dealing with Runtime Errors -- Suppressing Alerts -- Handling User Interrupts in Word, Excel, and Project -- Documenting Your Code -- The Bottom Line -- Chapter 18: 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 -- The Bottom Line -- Chapter 19: Securing Your Code with 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 -- The Bottom Line -- Part 6: Programming the Office Applications -- Chapter 20: Understanding the Word Object Model and Key Objects -- Examining the Word Object Model -- Working with the Documents Collection and the Document Object -- Working with the Selection Object -- Creating and Using Ranges -- Manipulating Options.

The Bottom Line -- Chapter 21: 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 -- The Bottom Line -- Chapter 22: 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 -- The Bottom Line -- Chapter 23: Working with Widely Used Objects in Excel -- Working with Charts -- Working with Windows -- Working with Find and Replace -- Adding Shapes -- The Bottom Line -- Chapter 24: Understanding the PowerPoint Object Model and Key Objects -- Getting an Overview of the PowerPoint Object Model -- Understanding PowerPoint's Creatable Objects -- Working with Presentations -- Working with Windows and Views -- Working with Slides -- Working with Masters -- The Bottom Line -- Chapter 25: Working with Shapes and Running Slide Shows -- Working with Shapes -- Working with Headers and Footers -- Setting Up and Running a Slide Show -- The Bottom Line -- Chapter 26: Understanding the Outlook Object Model and Key Objects -- Getting an Overview of the Outlook Object Model -- Working with the 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 -- The Bottom Line -- Chapter 27: Working with Events in Outlook -- Working with Application-Level Events -- Working with Item-Level Events -- Understanding Quick Steps -- The Bottom Line -- Chapter 28: 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 -- Using the DoCmd Object to Run Access Commands -- The Bottom Line -- Chapter 29: Manipulating the Data in an Access Database via 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 -- The Bottom Line -- Chapter 30: 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 -- The Bottom Line -- Chapter 31: Programming the Office 2013 Ribbon -- What Is XML? -- Hiding the Editing 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 -- The Bottom Line -- Appendix: The Bottom Line -- Chapter 1: Recording and Running Macros in the Office Applications -- Chapter 2: Getting Started with the Visual Basic Editor -- Chapter 3: Editing Recorded Macros -- Chapter 4: Creating Code from Scratch in the Visual Basic Editor -- Chapter 5: Understanding the Essentials of VBA Syntax.

Chapter 6: Working with Variables, Constants, and Enumerations.

A unique, comprehensive guide to creating custom apps with VBA Automating computing tasks to increase productivity is a goal for businesses of all sizes. Visual Basic for Applications (VBA) is a version of Visual Basic designed to be easily understandable for novice programmers, but still powerful enough for IT professionals who need to create specialized business applications. With this invaluable book, you'll learn how to extend the capabilities of Office 2013 applications with VBA programming and use it for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. Covers the basics of VBA in clear, systematic tutorials and includes intermediate and advanced content for experienced VB developers Explores recording macros and getting started with VBA; learning how to work with VBA; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files, ActiveX, the developer tab, content controls, add-ins, embedded macros, and security Anchors the content with solid, real-world projects in Word, Excel, Outlook, PowerPoint, and Access Covering VBA for the entire suite of Office 2013 applications, Mastering VBA for Microsoft Office 2013 is mandatory reading.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2019. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.

There are no comments on this title.

to post a comment.