摘要
Excel作为微软办公系统中的一员,在数据处理与统计方面虽然具有强大的功能,但若要把几百上千的Excel文件合并成一个Excel文件进行统计分析,Excel就不能很方便地满足用户的这种需求。介绍了如何利用VB编程工具编写Excel文件批量合并程序。
Excel Microsoft Office system as a member in the data processing and statistics,while having powerful,but if necessary to hundreds of thousands of Excel files into one Excel file for statistical analysis,Microsoft Excel can not be easily the reach of users that need.This article describes how to use VB programming tools for writing Excel file batch merge process.
出处
《电脑编程技巧与维护》
2011年第14期45-46,共2页
Computer Programming Skills & Maintenance