Abstract：Objective To explore the application of VBA language in the field of hospital statistics. Methods By writing VBA language of Microsoft office software, the computer can efficiently complete daily basic medical data daily report of outpatients and inpatients, monthly department medical quality publicity data, multidimensional and multi index query department data. Results Through the use of VBA language, the hospital realized the automatic filling of daily outpatient and inpatient medical data template, the automatic verification of inpatient transfer data, and the rapid filling of daily template data; by collecting the medical quality control data of each major functional department every month, it can be automatically split into independent Excel files according to the specified format and sent to each clinical department; the access database visualization method is used to conveniently query the multi index data of clinical departments. Conclusion VBA language can make accurate statistics of data, reduce manual errors, improve the efficiency of data processing, improve the quality of data statistics, ensure the reliability of data statistics, and help hospital statisticians get rid of the daily repetitive boring work, so as to focus on higher quality of mental work.
李昕昊，周火明，赖伏虎，徐俊，邓娟娟，罗燕. VBA 在医院统计领域的应用探讨[J]. 中国医院统计, 2021, 28(4): 372-379.
Li Xinhao，Zhou Huoming，Lai Fuhu，Xu Jun，Deng Juanjuan， Luo Yan. Application of VBA in the field of hospital statistics. journal1, 2021, 28(4): 372-379.
