VBA语言在我院药库智能化办公中的应用

The Application of VBA Language in Pharmaceutical Warehouse's Smart Office of Our Hospital

目的:利用Visual Basic for Applications(VBA)语言增加医院药库管理的自动化程度,提高工作效率。方法:总结我院药库通过编写微软Office办公软件的VBA语言,实现计算机自动完成购药计划的整理排序、分割加密、邮件发送、购药计划跟踪和效期文档管理等工作的经验。结果与结论:经过采用VBA编程,我院药库实现了购药计划的自动分割、购药计划及缺药预警的自动化发送、效期文档的自动预警等功能;购药计划的发送更准确快速,药品配送更及时,效期文档的管理也更加智能,节约了大量人力物力,大幅提高了工作效率,为药库智能化管理提供了新的思路和方法。

OBJECTIVE： To improve the automation of hospital pharmaceutical warehouse management by using Visual Basic for Applications （VBA） language so as to improve work efficiency. METHODS： Through editing VBA language of Microsoft office software, the experience of our hospital was swmmarized, such as letting the computer automatically sort, split and encrypt, pharmaceutical email and track purehase plan. RESULTS ＆ CONCLUSIONS ： By adopting VBA programming, our hospital has realized automatic splitting of the pharmaceutical purchase plan, sending pharmaceutical shortage warning and automatic warning document management. Pharmaceutical purchase plans are sent faster and drug distribution to our hospital is becoming more timely. The management of document that have a period of validity is becoming more intelligent. Massive manpower and resoure are saved, and the work efficiency is greatly improved. New ideas and methods for smart warehouse management are provided.