Udemy線上課程 Automating Microsoft Word from Excel Using VBA (含教材) 講師:Jose D. Sevilla 影音教學 英文發音 英語字幕版(DVD版)
Udemy線上課程AutomatingMicrosoftWordfromExcelUsingVBA(含教材)講師:JoseD.Sevilla影音教學英文發音英語字幕版(DVD版)內容說明:
AutomatingMicrosoftWordfromExcelUsingVBAisacoursedesignedtoteachstudentstheknowledgerequiredtostartAutomatingMicrosoftWordfromExcelUsingExcelVisualBasicForApplications("VBA").StudentswillbeabletoautomaterepetitivetaskswhenworkingwithWordDocumentsandprogrammaticallyaddcontenttoaDocumentwhiledevelopingtheskillstoeasilycustomizeparagraphs,workwithparagraphalignment,indentation,underline,etc.



AttheendofthiscoursestudentswillhavetheknowledgetointegrateExcelVBAdatatoMicrosoftWordAutomations.StudentswillalsohavetheknowledgetoautomatemostofthecommontasksrequiredwhenworkingwithWordDocuments.Userswillbelearning:



1.UnderstandthedifferentmethodstoautomateMicrosoftWordfromExcelusingVBA.

2.HowtoautomatethecreationofaWordDocumentusingEarlyBinding.

3.HowtoautomatethecreationofaWordDocumentusingLateBinding.

4.HowtoaddparagraphstoaWordDocumentprogrammatically.

5.Howtoformatparagraphsprogrammatically.

6.HowtoadddifferentListNumberingstylestoparagraphsprogrammatically.

7.HowtoaddFootertoaWordDocumentprogrammatically.

8.HowtoaddHeadertoaWordDocumentprogrammatically.

9.HowtoExtractDatafromExcelusingArraysandArrayLists.

10.HowtoIntegrateYourExceldataintoYourWordAutomation.

11.Howtofindandreplaceandfindandcustomizeparagraphsprogrammatically.
課程內容:
01-Introduction
001Introduction.mp4
001-ExcelVBA-MSWordAutomation.xlsm

02-UnderstandingmethodstoestablishcommunicationbetweenExcelandWord
002OverviewofmethodstoestablishcommunicationbetweenExcelandWord.mp4
002-AutomatingMSWordfromMSExcel.pptx

03-AutomatingthecreationofaWordDocument
003EarlyBinding.AutomatingthecreationofaWordDocument.mp4
004LateBinding.AutomatingthecreationofaWordDocument.mp4

04-TheDocumentObject-WorkingwithWordDocuments
005DocumentObjectandDocumentsCollectionOverview.mp4
005-DocumentObject.pptx
006DocumentObjectCodingLesson.mp4
006-DocumentObjectcodingrequirements.pptx

05-TheParagraphObject-WorkingwithParagraphs
007TheParagraphObjectandParagraphsCollectionOverview.mp4
007-ParagraphObjectandParagraphsCollection.pptx
008AddingaParagraphtoaWordDocument.mp4
009UnderstandingParagraphIndex.mp4
010AddingMultipleParagraphstoaWordDocument.mp4

06-FormattingWordDocuments
011FontObject.CustomizingParagraphs'Font.mp4
012ParagraphAlignment,IndentationandUnderline.mp4

07-FindObject
013Find,ReplaceandFormat.mp4

08-ListGalleriesObject.WorkingwithListFormat_NumberingStyle
014ApplyingListFormatwithListGalleries-PARTI.mp4
015ApplyingListFormatwithListGalleries-PARTII.mp4
016ApplyingListFormatwithListGalleries-PARTIII.mp4

09-WorkingwithFooter,PageNumberandHeader
017AddingFooterandPageNumbertoaWordDocument.mp4
018AddingaHeadertoaWordDocument.mp4

10-ExtractingDatafromExceltoPopulateitinWord
019UsingArraystoextractdatafromExceltopopulateatableinWord.mp4
020UsingArrayListstoextractdatafromExcelandpopulateitintableinWord.mp4
020-InstallingNetFramework_version3.5.pptx
021IntegrateYourExcelDatatoYourWordAutomation.mp4
相關商品:Udemy線上課程ExcelVBA程式設計(含教材)講師:贊贊小屋影音教學中文發音繁體中文字幕版(DVD版)Udemy線上課程職場手把手教學：一步一步實際運用EXCEL整合你的業務(實作資料自動串聯整合)(含教材)講師:SCOTTYEN影音教學中文發音繁體中文字幕版(DVD版)Udemy線上課程MicrosoftAzure雲端基礎實戰(含教材)講師:阿彬電腦影音教學中文發音繁體中文字幕版(DVD版)Udemy線上課程3D武器製作攻略(含教材)講師:眉角課程Megaclassonline影音教學英文發音繁體中文字幕版(DVD版)Udemy線上課程專案管理證書|專案管理課程(含教材)講師:MauricioRubio-AgileGuru&FounderofAgileKB|AgileLee&Ureducation影音教學英文發音中文字幕版(DVD版)