|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-vba-basic-to-super-advance-part2/
课程评论：没有评论
课程名称：Excel VBA 从基础到高级 第二部分（16小时） 课程概述：本课程分为四个部分，旨在教授学员使用Excel VBA处理大型和小型数据的方法。 第一部分，我们学习如何利用SCRIPTING库处理存储在Excel工作簿或文本文件中的数据。该库提供了FileSystemObject、Folder和Files以及Textstream等强大类，让我们能够访问文件夹、筛选文件，并进行数据编汇、文件修改、移动或删除等操作。同时，学习如何使用文件对话框，让用户选择任意文件夹进行相关工作，并能灵活处理文本文件的读写，包括覆盖或附加数据。 第二部分，聚焦于表单控件的使用，包括标签、文本框、组合框、列表框等。我们将理解用户表单的设计和属性，并探讨用户表单事件的重要性，以便于创建项目。在此过程中，学员的疑问将通过电子邮件或论坛得到及时解答。 第三部分，我们将学习错误处理的方法，如On Error Resume Next和Goto Err。通过分析可能出现错误的场景，学员将掌握如何忽略错误并继续执行VBA代码的方法。此外，还将学习如何自定义消息框和输入框。 第四部分，我们将探讨如何处理工作簿和工作表模块内的事件。这些自触发的宏可以在特定条件下自动执行，学员将了解Workbook Open、Sheet Activate等各种事件的用途，同时学习如何避免事件间的相互调用问题，以提升代码的稳定性。同时，通过项目实践增强对事件的掌握和信心。 本课程无特定教学大纲，适合对Excel VBA有兴趣的学员，适合不同水平的学习者。
In section1, We are Learning to deal with small or large data stored in excel workbooks or text files using a library called SCRIPTING which offers us amazing classes like FileSystemObject , Folder and Files and Textstream.How to go inside a folder and pick the needed files and then do the things like compiling data from them or modifying the files or moving them or deleting them.Learn how to use the file-dialogs so that user can choose any folder of his or her choice and work accordingly.Not just folders or Excel files -we are also going to see what to do if we have to overwrite or append the data in text files. Yes, we can even control the text files using scripting library, Very useful especially when you are dealing with big data.Skip the files while running loops which you do not want. Set the filters in the extensions using file dialogs. Learn all types of file dialogs like open dialog. save as dialog, folder dialog and also why and where we can use them.Customization of file dialog buttons, titles to how to open multiple files with them to make more user friendly and robust program which can be run in any machine irrespective of the drives or folder paths they have.Learn to manipulate text files using scripting library. We have everything discussed here from basic level to advance level when it comes to file and folder manipulations.In section2, we have covered all form controls like labels, textboxes, combo, listbox, frame, option buttons, check boxes and many more.From understanding the Userform control design and properties, you shall also see the magic of userform events which are very much required to create projects.All of your doubts will be answered via email or forum in 24 hours.in section3, you shall learn Error handlers like On error resume next and goto err. You shall see what are the scenarios when we already know we can have errors - VBA Errors so if we want to ignore those errors and keep continuing running the vba code, how to do that and first of all, why in first place , I will like to ignore the errors.We will then learn how to use and customize a message box and input box in vba with various examples.In section4, we will learn how to work with events which we write inside workbook and sheet modules. Why they are called self triggered macros and what are the conditions - Events names we can go and use it for different type of jobs.Learn amazing Events like - Workbook open, Sheet activate, sheet before delete, sheet change event, selection change events.When one event starts calling another event and you never planned for it, how to avoid this class using public variableFew projects for you to give you more confidence in Events
