Survey Data Read Automatically by Using VBA

doi:10.3969/j.issn.1006-2475.2014.02.051

Abstract

Abstract: 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 automatically reads and summarizes the data to Excel, for further statistical analysis of data. After practice, the program works well.

Key words: VBA, survey data, Word document, Excel spreadsheet, automatically read

CLC Number:

TP317

TANG Yan, HAN Ai-qing, ZHAI Xing.

Survey Data Read Automatically by Using VBA

[J]. Computer and Modernization, doi: 10.3969/j.issn.1006-2475.2014.02.051.

References 14

[1]	彭小平,颜清. Word中基于VBA的实验数据自动转换技术[J]. 计算机与现代化, 2006(4):7-8,23.
[2]	孙晓伟,毕晓清,吴洪越,等. 基于DOM和VBA的Word文档数据交互式抽取[J]. 计算机应用与软件, 2013,30(2):113-115.
[3]	John Paul Mueller. VBA for Dummies[M]. Wiley Publishing, 2007.
[4]	廖金辉,邓胜军. Excel工作表与Word表格的数据交换[J]. 信息技术, 2006,30(5):20-23.
[5]	韩爱庆,马星光,张未未,等. 基于VBA的Word格式转为Unicode格式的方法[J]. 计算机与现代化, 2013(9):236-238.
[6]	林宫. 基于OLE和VBA的数据库与Word数据交互研究[J]. 福州大学学报:自然科学版, 2006,34(6):831-835.
[7]	Microsoft. Office for Developers[EB/OL]. http://msdn.microsoft.com/en-us/office/, 2013-09-30.
[8]	Excel Home. Excel应用大全[M]. 北京:人民邮电出版社, 2008:785-809.
[9]	顾海花. VBA在Word和Excel数据交互中的应用[J]. 南通职业大学学报, 2003,17(3):49-50.
[10]	王殿佑. Word VBA应用程序在处理文档未知重复内容中的应用[J]. 电脑编程技巧与维护, 2010(2):19-20.
[11]	杨晓亮. Word VBA高效排版范例应用[M]. 北京:中国青年出版社, 2005.
[12]	范晓燕,周涛峰. 利用VBA实现Word文档的批量拆分与合并[J]. 电脑知识与技术, 2011,7(7):1554-1556.
[13]	汤怀. 基于VBA技术的Word智能评分的设计与实现[J]. 福建电脑, 2011,27(6):117-118,156.
[14]	杨晓云,赵希武. 基于VBA学位论文格式模板的设计[J]. 太原大学教育学院学报, 2012,30(3):88-91.

Survey Data Read Automatically by Using VBA

Knowledge

Abstract

Cite this article

share this article

References 14

Related Articles 10

Recommended Articles

Metrics

Comments

[1]	SHAO Shi-yun, ZHOU Yu, YANG Lei, ZHONG Mao-sheng, DAI Rui, ZHAO Jia-le. An Efficient Entity Identification Method for Electric Bidding Documents Based on Conditional Random Field [J]. Computer and Modernization, 2020, 0(12): 72-77.
[2]	HAN Ai-qing;MA Xing-guang;ZHANG Wei-wei;ZHAI Xing. Transferring Word Text to Unicode Text File by Using VBA [J]. Computer and Modernization, 2013, 1(9): 236-238.
[3]	ZHANG Zheng;. Design and Implementation of Auto-filled Bulk Web Forms System [J]. Computer and Modernization, 2013, 1(2): 169-172.
[4]	HAN Ai-qing;XUE Lei;SHEN Jun-hui;GUO Feng-ying;TANG Yan. Random Producing Test Paper Algorithm with Multi-parameters Constraint Based on Data Dictionary [J]. Computer and Modernization, 2013, 218(10): 16-18.
[5]	DENG Xiu-lan;LI Guang-zhen. Realization of Automatic Word Paper Marking System Based on VBA Technology [J]. Computer and Modernization, 2012, 1(9): 219-221.
[6]	WANG Xiang-ju. Implementation of Methods for Converting　Word File Image into Database [J]. Computer and Modernization, 2012, 198(2): 82-85.
[7]	DENG Chao-hui. Design and Implementation of Setting up Position for Institutional  Organization Scoring System Based on Excel VBA [J]. Computer and Modernization, 2012, 1(10): 213-215.
[8]	LI Hua;ZHANG Wei-na. Design of Automatic Grading System for Standardized Examination Papers by Excel [J]. Computer and Modernization, 2012, 1(1): 199-202,.
[9]	LIN Mu-chan;CAI Ying. Design and Implementation of Digital Photos Cataloging Template Based on Excel VBA [J]. Computer and Modernization, 2011, 193(9): 195-198.
[10]	LI Lan-you;Wang Ji-sheng. Implementation and Research on Word Output Technology for Web [J]. Computer and Modernization, 2010, 1(3): 138-3.