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.