Udemy線上課程 Automating Microsoft Word from Excel Using VBA (含教材) 講師:Jose D. Sevilla 影音教學 英文發音 英語版(DVD版)
內容說明:
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 using Early Binding.
3. How to automate the creation of a Word Document using Late Binding.
4. How to add paragraphs to a Word Document programmatically.
5. How to format paragraphs programmatically.
6. How to add different List Numbering styles to paragraphs programmatically.
7. How to add Footer to a Word Document programmatically.
8. How to add Header to a Word Document programmatically.
9. How to Extract Data from Excel using Arrays and ArrayLists.
10. How to Integrate Your Excel data into Your Word Automation.
11. How to find and replace and find and customize paragraphs programmatically.
課程內容:
01 - Introduction
001 Introduction.mp4
001-Excel VBA - MS Word Automation.xlsm
02 - Understanding methods to establish communication between Excel and Word
002 Overview of methods to establish communication between Excel and Word.mp4
002-Automating MS Word from MS Excel.pptx
03 - Automating the creation of a Word Document
003 Early Binding. Automating the creation of a Word Document.mp4
004 Late Binding. Automating the creation of a Word Document.mp4
04 - The Document Object - Working with Word Documents
005 Document Object and Documents Collection Overview.mp4
005-Document Object.pptx
006 Document Object Coding Lesson.mp4
006-Document Object coding requirements.pptx
05 - The Paragraph Object - Working with Paragraphs
007 The Paragraph Object and Paragraphs Collection Overview.mp4
007-Paragraph Object and Paragraphs Collection.pptx
008 Adding a Paragraph to a Word Document.mp4
009 Understanding Paragraph Index.mp4
010 Adding Multiple Paragraphs to a Word Document.mp4
06 - Formatting Word Documents
011 Font Object. Customizing Paragraphs' Font.mp4
012 Paragraph Alignment, Indentation and Underline.mp4
07 - Find Object
013 Find, Replace and Format.mp4
08 - ListGalleries Object. Working with List Format_Numbering Style
014 Applying List Format with List Galleries - PART I.mp4
015 Applying List Format with List Galleries - PART II.mp4
016 Applying List Format with List Galleries - PART III.mp4
09 - Working with Footer, Page Number and Header
017 Adding Footer and Page Number to a Word Document.mp4
018 Adding a Header to a Word Document.mp4
10 - Extracting Data from Excel to Populate it in Word
019 Using Arrays to extract data from Excel to populate a table in Word.mp4
020 Using ArrayLists to extract data from Excel and populate it in table in Word.mp4
020-Installing Net Framework_version 3.5.pptx
021 Integrate Your Excel Data to Your Word Automation.mp4
專業知識教學
