Abstract:

To complete data aggregation of the same variety in different trial points in regional trials efficiently, the authors developed the software based on Excel VBA. The software opens the word documents with source data one by one and extracts data from multiple tables in a file by executing multiple loops, then exports the table data from the same location in different files to a specified Excel worksheet. By computing, it can open file in batches in the background and realize the extraction of the same table data in each file and the summary of the same variety data in different trial points quickly. In the process of table data extraction, it could split and extract the table data once by calculating the row number in the summary table, which satisfies the requirement of regional trial data’s bulk extraction and aggregation with high efficiency and lays a foundation for subsequent data processing. The software is easy to operate and has fast running speed and high efficiency. It is not only suitable for data summary of regional trial, but also for other similar data summary and processing. It has certain value of popularization and application in data interaction between Office Word and Excel.

Key words: Regional Trial, Excel VBA, Software Development, Table Data in Word, Aggregate Data