摘要
针对人工编制Word格式检验报告时存在的重复输入、耗时、易错等问题,介绍了一种基于VBA的矿用产品检验报告编制方案。该方案通过Word文档中的VBA程序提供用户输入界面,并自动调用相关Excel和Word文档,完成所需信息的提取、保存及检验报告的填写。该方案避免了重复的文字输入,提高了工作效率和办公自动化程度,实际应用效果良好。
In view of problems such as duplicate input,time-consuming,error-prone and so on existed in manually compiled inspection reports with format of Word,the paper proposed a compilation scheme of mine-used products inspection report based on VBA.The scheme provides user input interface through VBA program in Word document,calls relevant Excel and Word documents automatically and completes extraction and preservation of required information and writing of inspection reports.The scheme can avoid duplicate input and promote efficiency and level of office automation.The practical application result is good.
出处
《工矿自动化》
2011年第11期95-97,共3页
Journal Of Mine Automation
关键词
矿用产品
VBA
检验报告
办公自动化
mine-used product
VBA
inspection report
office automation
