基于VBA的多工作簿信息汇集和解析方法

VBA Based Multi-workbook Information Collection and Analytical Methods

来自各部门的Excel工作簿中的数据,需要汇集到总表的对应单元格中,并对信息加以解析和计分。设计、运行程序,自动打开多个工作簿并进行处理,构成总表。阐述了工作簿、工作表、栏目、单元格内规范化信息格式约定,符号信息处理方法,并用VBA编程实现。

Data of Excel wookbooks from every department,need to collect into correspond unit cell of chief table,then parse characters and count point.Design 、run program to automatic opening every workbooks,and began data processing,come into general workbooks.Expound on standard in formation form stipulation of Workbooks、Sheets、cells,way of parsing codes,and Complete by VBA program.