基于VBA实现批量证件的制作  

Implementation of Mass Production of Documents Based on VBA

作　　者：李淑梅[1] 李政[1] 

机构地区：[1]吉林师范大学,吉林四平136000

出　　处：《廊坊师范学院学报（自然科学版）》2010年第6期41-43,共3页Journal of Langfang Normal University(Natural Science Edition)

摘　　要：Excel作为现今流行的Office办公套装软件的一个重要成员,其内置的标准宏语言VBA使其自动化水平得到了极大的扩充。通过对Excel中VBA的开发和应用可以实现批量证件的制作,只需简单操作就可以制作出批量的带数码照片的证件,还可以实现证件信息的双面打印。这充分展示了Office的自动化水平,体现了VBA在Excel乃至在Office中的重要价值。Excel is a key member of the current popular office suite software Office.The standard macro language VBA,built in Excel,has been greatly expanded level of automation.Based on the development and application of Excel VBA,a batch of documents produced software is realized.It can not only create a batch of documents with digital photos by simple operations,but also print the documents of double-sided.It fully demonstrates the Office automation level,and reflects the important value of VBA in Excel as well as in the Office.

关 键 词：VBA 代码 批量制作 

分 类 号：TP317[自动化与计算机技术—计算机软件与理论]