The Application of VBA Language in Pharmaceutical Warehouse’s Smart Office of Our Hospital / 中国药房
China Pharmacy
; (12): 987-989, 2016.
Article
in Zh
| WPRIM
| ID: wpr-504320
Responsible library:
WPRO
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.
Full text:
1
Database:
WPRIM
Language:
Zh
Journal:
China Pharmacy
Year:
2016
Document type:
Article