Udemy線上課程 Automating Microsoft Word from Excel Using VBA (含教材) 講師:Jose D. Sevilla 影音教學 英文發音 英語字幕版(DVD版)
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
相關商品:
Udemy線上課程 Excel VBA程式設計 (含教材) 講師:贊贊 小屋 影音教學 中文發音 繁體中文字幕版(DVD版)
Udemy線上課程 職場手把手教學：一步一步實際運用 EXCEL 整合你的業務(實作資料自動串聯整合) (含教材) 講師:SCOTT YEN 影音教學 中文發音 繁體中文字幕版(DVD版)
Udemy線上課程 Microsoft Azure雲端基礎實戰 (含教材) 講師:阿彬 電腦 影音教學 中文發音 繁體中文字幕版(DVD版)
Udemy線上課程 3D武器製作攻略 (含教材) 講師:眉角課程 Megaclass online 影音教學 英文發音 繁體中文字幕版(DVD版)
Udemy線上課程 專案管理證書 | 專案管理課程 (含教材) 講師:Mauricio Rubio - Agile Guru & Founder of AgileKB | AgileLee & Ureducation 影音教學 英文發音 中文字幕版(DVD版)
