基于VBA技术实现调查问卷数据自动读取

Survey Data Read Automatically by Using VBA

针对收集到大量Word格式的调查问卷后,无法高效获取文档中有价值的信息这一普遍存在的问题,使用VBA编程技术把多个Word文档的数据,自动读取并汇总到Excel表格中,以便进一步统计分析数据。经实践,该程序行之有效。

A large number of surveys data are collected by using Word document, but they can＇t be efficient to obtain valuable information. This paper presents a solution by using VBA programming to multiple Word format document data, which automati- cally reads and summarizes the data to Excel, for further statistical analysis of data. After practice, the program works well.