£75.00 – £2,250.00
This Advanced Word VBA online training course is designed for users who are already comfortable with the basics of Word VBA macros, and who have progressed beyond relying on the Macro Recorder.
Sign up for a free trial of Advanced Microsoft Word VBA Macro Programming
The advanced Word VBA online course carries on from where the above Introductory course finishes.
The main purpose of this course is to take a deep dive into programming the Word VBA object model; but in a practical, hands-on kind of way.
Here’s a summary of what you will learn:
So, by the end of our self-paced Advanced Word VBA online training course, you will have a good grasp of all of the intermediate and advanced Word VBA programming techniques that you’ll need to master, in order to feel comfortable when undertaking Word VBA projects; either in the workplace, or as a consultant.
COURSE OUTLINE
9. The Application object
9.1: Application.UserName
9.2: Application.System
9.3: Application.OnTime
9.4: Application.FontNames
10. The Document Object
10.1: Processing all Files in a Folder
10.2: Archiving Old Files
10.3: The Documents Collection
10.4: Testing Whether a Document is Open
10.5: Creating, Opening and Closing Documents
11. The Range and Selection Objects
11.1: The Range and Selection Objects compared
11.2: Verifying the Selection Type
11.3: Verifying the Selection Story
11.4: Verifying Selection or Range Information
12. Working with Text
12.1: Working with Paragraphs
12.2: Working with Words and Characters
12.3: Copying Text
12.4: Inserting Text
12.5: Using the Find Object
12.6: Changing the Case of Text
12.7: Working with Lists
12. 8: Formatting text
12.9: Working with styles
12.10: Creating a Table of Contents
13. Sections, Headers and Footers
13.1: Creating Sections
13.2: The PageSetup Object
13.3: Creating Headers and Footers
13.4: The LinkToPrevious Property
13.5: Odd and Even Headers and Footers
13.6: Inserting Page Numbers
13.7: Inserting an Image into a Header
14. Working with Tables
14.1: Creating Tables
14.2: Merging cells
14.3: Formatting Tables
14.4: Converting Text to a Table
14.5: Transposing a table
14.6: Sorting Table Data
15. Content Controls and Interactive Forms
15.1: Customizing Placeholder Text
15.2: Creating Content Controls Programmatically
15.3: Control Events
15.4: Drop-down Lists and Combo Boxes
15.5: Using the Picture Control
16. Distributing Your VBA Solutions
16.1: Distributing raw VBA code
16.2: Distributing a VBA module
16.3: Distributing a Word Addin
17. Targeting Other Office Programs
17.1: Referencing other Office Applications
17.2: Controlling Excel from a Word Macro
17.3: Controlling Outlook from a Word Macro
17.4: Controlling PowerPoint from a Word Macro
User | Single User, 2 Users, 5 Users, 10 Users, 25 Users, 50 Users, 100 Users |
---|