The Application of VBA Language in Pharmaceutical Warehouse’s Smart Office of Our Hospital
10.6039/j.issn.1001-0408.2016.07.37
- VernacularTitle:VBA语言在我院药库智能化办公中的应用
- Author:
Zhaohui JIN
;
Jinjian GU
;
Minglin ZHENG
;
Miao ZHAO
- Publication Type:Journal Article
- Keywords:
Hospital pharmaceutical warehouse;
Visual Basic for Applications;
Smart office
- From:
China Pharmacy
2016;27(7):987-989
- CountryChina
- Language:Chinese
-
Abstract:
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 of-fice 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 re-alized automatic splitting of the pharmaceutical purchase plan,sending pharmaceutical shortage warning and automatic warning doc-ument 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.