基于 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 Excell, for further statistical analysis of data .After practice, the program works well .