The Application of VBA Language in Pharmaceutical Warehouse’s Smart Office of Our Hospital / 中国药房

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.