Excel 是一个非常优秀的报表制作软件，用VBA可以控制其生成优秀的报表，本文通过添加查询语句的方法，即用Excel中的获取外部数据的功能将数据很快地从一个查询语句中捕获到EXCEL中,比起往每个CELL里写数据的方法提高许多倍。-Excel is a very good statement of the production of software, can control its use VBA to generate excellent returns, this article by adding query method, which uses Excel in the external data access data quickly from a query to capture the EXCEL in, compared to each CELL write data many times improve.