Automating Microsoft Word From Excel Using Vba | Advanced

Embracing the Magic of Excel VBA Automation

What you'll learn

How to work with Word Documents

How to work with Paragraphs

How to integrate Excel data with Word

How to format paragraphs

How to design and implement a basic project

How to create some re-usable functionalities and implement it in your code

How to write advanced sub-procedures

How to work with functions and implement them in your code

Requirements

Intermediate Excel VBA knowledge

Basic knowledge on how to automate word using Excel VBA

Desire to learn and expand your current skills

Basic to Intermediate Microsoft Word skills

Description

Automating Microsoft Word from Excel Using VBA is a course designed to teach students the knowledge required to start Automating Microsoft Word from Excel Using Excel Visual Basic For Applications ("VBA"). Students will be able to automate repetitive tasks when working with Word Documents and programmatically add content to a Document while developing the skills to easily customize paragraphs, work with paragraph alignment, indentation, underline, etc.At the end of this course students will have the knowledge to integrate Excel VBA data to Microsoft Word Automations. Students will also have the knowledge to automate most of the common tasks required when working with Word Documents.  Users will be learning:1. Understand the different methods to automate Microsoft Word from Excel using VBA.2. How to automate the creation of a Word Document.3. How to add paragraphs to a Word Document programmatically.4 How to format paragraphs programmatically.5. How to add Footer text and page numbering to a Word Document programmatically.6. How to add Header to a Word Document programmatically.7. How to Extract Data from Excel using ArrayLists.8. How to Integrate Your Excel data into Your Word Automation.9. How to start working on basic projects to gain some experience.10 . How to define project requirements.11. How to work based on project requirements.12. How to Create a basic project design.13. How to implement a project design based on a basic project architecture/design.14. How to create a utilities module with multiple sub-procedures and functions for re-usable code.15. How to program using advanced concepts.As a Software Engineer, I have worked in multiple projects in different technologies, Excel VBA Microsoft Word automation has been one of them, I have developed very complex projects automating Microsoft Word from Excel using VBA and I designed this course to provide my students with the tools they need to start their journey automating Microsoft Word from Excel using VBA.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What If I do not have any knowledge Automating MS Word from Excel using VBA?

Lecture 3 How to make the most out of this course?

Section 2: What is VBA?

Lecture 4 What is VBA?

Section 3: Methods to Establish Communication between Excel and Word

Lecture 5 Understanding Methods to Establish communication between Excel & Word

Section 4: Project I- Automating the creation of a Word Document using Advanced Concepts

Lecture 6 Project 1 Overview

Lecture 7 Write base code for Project

Lecture 8 Utilities. Write code to add one or more blank spaces

Lecture 9 Utilities. Write code to return alignment to be applied to paragraphs

Lecture 10 Adjusting Function that Processes and Returns Alignment Type

Lecture 11 Utilities. Write code to add Paragraphs

Lecture 12 Utilities. Write code to add Horizontal Lines

Lecture 13 Declare All variables

Lecture 14 Assign values to all variables Part I

Lecture 15 Assign values to all variables Part II

Lecture 16 Assign values to variables Part III

Lecture 17 Write code to add Header Text

Lecture 18 Write code to add Footer Text and Page Numbering

Lecture 19 Write code to add Content to Word Document Part I

Lecture 20 Write code to add Content to Word Document Part II

Lecture 21 Write code to add Content to Word Document Part III

Lecture 22 Run Automation

Section 5: Project II - Automate Creation of Word Document and Integrate Excel Data

Lecture 23 Project Overview

Lecture 24 Working File overview

Lecture 25 Create functionality to get Last Paragraph Index in Word Document

Lecture 26 Create functionality to get Last Table Index in a Word Document

Lecture 27 Create functionality to add space after adding a table to Word Document

Lecture 28 Part I - Create functionality to Extract Data from Excel and add it to Word

Lecture 29 Part II - Create functionality to Extract Data from Excel and add it to Word

Lecture 30 Part III - Create functionality to Extract Data from Excel and add it to Word

Lecture 31 Part IV - Create functionality to Extract Data from Excel and add it to Word

Lecture 32 Create functionality to process request to add table to word

Lecture 33 Create re-usable code to add Scorers by position section to word

Lecture 34 Create base code for Word Automation

Lecture 35 Create code for Main Section

Lecture 36 Create Best Scorers Section

Lecture 37 Create Header section

Lecture 38 Create Footer section

Lecture 39 Run Automation

Accountants,Technical Business Analysts,Contract Administrators,Deal Specialists,Agreement Specialists,Any professional who wants to solve a problem by automating MS Word and MS Excel