基于VBA的快速测试自动化设计与实现

Design and implementation of rapid test automation based on VBA

文章针对雷达批生产中测试自动化的迫切需求,提出一种简明实用的基于VBA编程环境、VISA标准库和SCPI命令的自动化程序开发方法,以矢量网络分析仪对射频综合网络的测试为实例,阐述了开发流程和设计思路,使集成调试人员能够灵活地根据被测产品自主完成编程,快速实现仪器程控、数据采集与处理分析、验收测试报告数据的自动导入等。结果表明,使用该方法开发的测试自动化程序具有便利性、实用性、扩展性,大幅提升了测试效率。目前,已在实际工程中应用。

For the urgent need of test automation in radar batch production,this paper presents a concise and practical method of automation program development based on VBA programming environment,VISA standard library and SCPI commands,taking the testing of an RF synthetic network by a vector network analyzer as an example,it helps engineers complete programming flexibly according to the product,rapid implement instrument programming control,data acquisition and processing analysis,automatic import of acceptance test report data,etc.The results show that the testing automation program developed using this method has convenience,practicality and scalability,greatly improving testing efficiency.At present,it has been put into practical engineering applications.