一种基于Excel 2010环境下VBA技术的实用文件管理工具

Practical File Management Tool Base on VBA in Excel 2010

针对纷繁复杂的文件管理问题,利用Excel 2010新环境下的VBA技术,在Excel2010中开发了一个基于VBA技术的实用文件管理工具,实现将指定文件夹中的所有文件名提取出来保存到Excel工作表中,并自动添加和删除与真实文件的超链接.借助Excel方便快捷的查找功能,快速地实现文件的搜索和定位,方便地进行相关主题文献的归类、注解、阅读和更新.

Aimed at the complicated file management issues, VBA in Excel 201 is employed to develop a practical file management tool base on VBA. This tool can extract all filenames from the specified folder, and save them to the worksheet in Excel. It can also automatically add or delete the hyperlinks between the filename and the real file in folder. By means of convenient and efficient look-up function of Excel, file＇s searching and locating are quick implemented, and the classification, annotation, reading and update of the literature related subject are conveniently conducted.