Automating Microsoft Word from Excel using VBA | Advanced
https://DevCourseWeb.com
Published 5/2023 Created by Jose D. Sevilla MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Genre: eLearning | Language: English | Duration: 39 Lectures ( 2h 45m ) | Size: 1.23 GB
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
~Get Your Files Here !/1. Introduction/1. Introduction.mp4
2 MB
~Get Your Files Here !/1. Introduction/2. What If I do not have any knowledge Automating MS Word from Excel using VBA.mp4
4.8 MB
~Get Your Files Here !/1. Introduction/3. How to make the most out of this course.mp4
1.5 MB
~Get Your Files Here !/2. What is VBA/1. What is VBA.mp4
7.5 MB
~Get Your Files Here !/2. What is VBA/1.1 Automating MS Word from MS Excel.pptx
46.9 KB
~Get Your Files Here !/3. Methods to Establish Communication between Excel and Word/1. Understanding Methods to Establish communication between Excel & Word.mp4
11 MB
~Get Your Files Here !/3. Methods to Establish Communication between Excel and Word/1.1 Automating MS Word from MS Excel.pptx
73.5 KB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/1. Project 1 Overview.mp4
24.3 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/1.1 Automating MS Word from MS Excel.pptx
50.4 KB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/1.2 Excel VBA - MS Word Automation II - Project 1.xlsm
11.9 KB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/1.3 MS Word Automation using Excel VBA - Project I.docx
22.7 KB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/10. Assign values to all variables Part II.mp4
53.5 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/11. Assign values to variables Part III.mp4
86.3 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/12. Write code to add Header Text.mp4
54.7 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/13. Write code to add Footer Text and Page Numbering.mp4
62.2 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/14. Write code to add Content to Word Document Part I.mp4
34.5 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/15. Write code to add Content to Word Document Part II.mp4
62.7 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/16. Write code to add Content to Word Document Part III.mp4
40 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/17. Run Automation.mp4
51.2 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/2. Write base code for Project.mp4
31.4 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/2.1 Excel VBA - MS Word Automation II - Project I.xlsm
11.9 KB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/3. Utilities. Write code to add one or more blank spaces.mp4
27.2 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/4. Utilities. Write code to return alignment to be applied to paragraphs.mp4
19.6 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/5. Adjusting Function that Processes and Returns Alignment Type.mp4
6.7 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/6. Utilities. Write code to add Paragraphs.mp4
34.5 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/7. Utilities. Write code to add Horizontal Lines.mp4
9.1 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/8. Declare All variables.mp4
78.3 MB
~Get Your Files Here !/4. Project I- Automating the creation of a Word Document using Advanced Concepts/9. Assign values to all variables Part I.mp4
46.2 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/1. Project Overview.mp4
16.2 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/1.1 Automating MS Word from MS Excel.pptx
66.9 KB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/10. Create functionality to process request to add table to word.mp4
25.8 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/11. Create re-usable code to add Scorers by position section to word.mp4
21.7 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/12. Create base code for Word Automation.mp4
20.3 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/13. Create code for Main Section.mp4
48.9 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/14. Create Best Scorers Section.mp4
54.4 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/15. Create Header section.mp4
26.6 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/16. Create Footer section.mp4
41.2 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/17. Run Automation.mp4
24.7 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/2. Working File overview.mp4
7.3 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/2.1 Excel VBA - MS Word Automation - Project II.xlsm
29.4 KB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/3. Create functionality to get Last Paragraph Index in Word Document.mp4
15.6 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/4. Create functionality to get Last Table Index in a Word Document.mp4
8.8 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/5. Create functionality to add space after adding a table to Word Document.mp4
11.3 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/6. Part I - Create functionality to Extract Data from Excel and add it to Word.mp4
23.3 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/7. Part II - Create functionality to Extract Data from Excel and add it to Word.mp4
52.1 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/8. Part III - Create functionality to Extract Data from Excel and add it to Word.mp4
70.1 MB
~Get Your Files Here !/5. Project II - Automate Creation of Word Document and Integrate Excel Data/9. Part IV - Create functionality to Extract Data from Excel and add it to Word.mp4
50.8 MB
~Get Your Files Here !/Bonus Resources.txt
386 B
Alternative Torrents for 'Udemy Automating Microsoft Word from Excel using VBA Advanced'.
