Udemy - Automating Microsoft Word from Excel using VBA Advanced

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1. Introduction
• 1. Introduction.mp4 (2.0 MB)
• 2. What If I do not have any knowledge Automating MS Word from Excel using VBA.mp4 (4.8 MB)
• 3. How to make the most out of this course.mp4 (1.5 MB)
2. What is VBA
• 1. What is VBA.mp4 (7.5 MB)
• 1.1 Automating MS Word from MS Excel.pptx (46.9 KB)
3. Methods to Establish Communication between Excel and Word
• 1. Understanding Methods to Establish communication between Excel & Word.mp4 (11.0 MB)
• 1.1 Automating MS Word from MS Excel.pptx (73.5 KB)
4. Project I- Automating the creation of a Word Document using Advanced Concepts
• 1. Project 1 Overview.mp4 (24.3 MB)
• 1.1 Automating MS Word from MS Excel.pptx (50.4 KB)
• 1.2 Excel VBA - MS Word Automation II - Project 1.xlsm (11.9 KB)
• 1.3 MS Word Automation using Excel VBA - Project I.docx (22.7 KB)
• 10. Assign values to all variables Part II.mp4 (53.5 MB)
• 11. Assign values to variables Part III.mp4 (86.3 MB)
• 12. Write code to add Header Text.mp4 (54.7 MB)
• 13. Write code to add Footer Text and Page Numbering.mp4 (62.2 MB)
• 14. Write code to add Content to Word Document Part I.mp4 (34.5 MB)
• 15. Write code to add Content to Word Document Part II.mp4 (62.7 MB)
• 16. Write code to add Content to Word Document Part III.mp4 (40.0 MB)
• 17. Run Automation.mp4 (51.2 MB)
• 2. Write base code for Project.mp4 (31.4 MB)
• 2.1 Excel VBA - MS Word Automation II - Project I.xlsm (11.9 KB)
• 3. Utilities. Write code to add one or more blank spaces.mp4 (27.2 MB)
• 4. Utilities. Write code to return alignment to be applied to paragraphs.mp4 (19.6 MB)
• 5. Adjusting Function that Processes and Returns Alignment Type.mp4 (6.7 MB)
• 6. Utilities. Write code to add Paragraphs.mp4 (34.5 MB)
• 7. Utilities. Write code to add Horizontal Lines.mp4 (9.1 MB)
• 8. Declare All variables.mp4 (78.3 MB)
• 9. Assign values to all variables Part I.mp4 (46.2 MB)
5. Project II - Automate Creation of Word Document and Integrate Excel Data
• 1. Project Overview.mp4 (16.2 MB)
• 1.1 Automating MS Word from MS Excel.pptx (66.9 KB)
• 10. Create functionality to process request to add table to word.mp4 (25.8 MB)
• 11. Create re-usable code to add Scorers by position section to word.mp4 (21.7 MB)
• 12. Create base code for Word Automation.mp4 (20.3 MB)
• 13. Create code for Main Section.mp4 (48.9 MB)
• 14. Create Best Scorers Section.mp4 (54.4 MB)
• 15. Create Header section.mp4 (26.6 MB)
• 16. Create Footer section.mp4 (41.2 MB)
• 17. Run Automation.mp4 (24.7 MB)
• 2. Working File overview.mp4 (7.3 MB)
• 2.1 Excel VBA - MS Word Automation - Project II.xlsm (29.4 KB)
• 3. Create functionality to get Last Paragraph Index in Word Document.mp4 (15.6 MB)
• 4. Create functionality to get Last Table Index in a Word Document.mp4 (8.8 MB)
• 5. Create functionality to add space after adding a table to Word Document.mp4 (11.3 MB)
• 6. Part I - Create functionality to Extract Data from Excel and add it to Word.mp4 (23.3 MB)
• 7. Part II - Create functionality to Extract Data from Excel and add it to Word.mp4 (52.1 MB)
• 8. Part III - Create functionality to Extract Data from Excel and add it to Word.mp4 (70.1 MB)
• 9. Part IV - Create functionality to Extract Data from Excel and add it to Word.mp4 (50.8 MB)
• Bonus Resources.txt (0.4 KB)