Increased Efficiency: Formulary Drug Conversion Automation Using Visual Basic-Based Macros with Attachmate Reflections in the Pharmacy Setting

Abstract

Health care automation provides opportunities for health care agencies to save time, save money, and increase patient safety. The Department of Veterans Affairs medical centers use a program, Attachmate Reflections, for pharmacy medication order verification. This program is a command line interface that allows the use of macros, or programmed automated routines, that have the ability to automate repetitive tasks. Through the use of macro programming at the VISN 11 VA medical centers, this author was able to automate converting patients from Combivent MDI inhalers to its successor Combivent Respimat inhalers due to the MDI inhaler being withdrawn from the market. Usage of the macro resulted in a time savings of 649.1 hours, cost savings of $32,748.36, and increased patient safety by providing consistent medication instructions, correct dispense quantities, correct prescription day supply, and correct number of refills remaining on the prescription.