|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-excel-vba-files-and-folder-handling/
课程评论：没有评论
Coursera 上的 Excel VBA 系列课程（文件和文件夹处理 - Series 6）专注于教授学员如何利用 VBA 脚本库（SCRIPTING）来高效地处理各种文件和文件夹。 **课程内容涵盖：** * **核心对象：** 深入学习 `FileSystemObject`、`Folder` 和 `File` 等关键类，从基础概念到高级应用。 * **文件操作：** 掌握如何遍历文件夹、选择特定文件，并进行数据提取、文件修改、移动和删除等操作。 * **文件对话框：** 学习使用各种文件对话框（如打开、另存为、文件夹选择），允许用户自由选择文件或文件夹，并自定义对话框按钮和标题，提高程序的易用性和健壮性。 * **文本文件处理：** **重点**学习使用脚本库操作文本文件，包括覆盖（overwrite）和追加（append）数据，尤其适用于处理大数据。 * **循环与条件：** 学习使用集合循环（Collection Loops）处理大量文本文件或文件夹，并结合条件判断（if conditions）实现更精细的操作。 * **项目实践：** 通过两个实际项目，将所学知识融会贯通，展示库和循环的实际应用。 * **实用技巧：** 学习在循环中跳过不需要的文件，以及通过文件对话框设置文件扩展名过滤器。 **课程亮点：** * **全面性：** 从基本到高级，涵盖文件和文件夹处理的方方面面。 * **实操性：** 通过项目实践和练习，帮助学员掌握核心技能。 * **用户友好：** 教授如何创建用户友好的程序，使其能够在任何机器上运行。 * **支持：** 提供习题练习和答疑服务。 本课程适合所有希望提升 Excel VBA 在文件和文件夹管理能力的用户，尤其是在处理大量数据时，将大有裨益。
We are Learning to deal with every type of file and folders data - Using one of the important library in VBA called SCRIPTING which offers us amazing classes like FileSystemObject , Folder and Files etc.Use of Filesystem object class, text stream class, folder and file classes are discussed in this series from basic to advance.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.Introducing the Collection Loops used to deal with text file data or hundred of folders or thousand of files.Use if conditions and collection loops in the two amazing projects to show you the real use of libraries and loops.Assignment are added so that you can practice and check your score. Doubts will always be answered if asked.
