Excel is a data processing software in general use. It is well received by college workers because of its ability to handle the data of multi-platform system data. In daily work, in order to facilitate the normalization of data processing, Excel VBA is often used in automated data processing. This paper mainly discussed how to build a modular system with Excel VBA to process the data in workflow.