论文部分内容阅读
目的:利用Excel VBA,通过药物INN英文名实现自动获取药物的限定日剂量(Defined Daily Dose,DDD)。方法:通过代码动态设置Excel VBA Query Tables对象中Add方法的Web查询字符串,变量为药物INN英文名,实现自动获取药物的DDD值。结果:利用Excel VBA能简便的实现自动获取药物的DDD值,并且通过对代码的扩展,可实现自动计算药物的用药频度(DDDs)以及与DDDs相关的其他用药指标,较人工操作简便、快捷、高效及准确。结论:利用EXCEL VBA自动获取药物DDD值切实可行,提高了药物利用分析的效率和准确性,具有较高的实际应用价值。
OBJECTIVE: To automatically obtain the Defined Daily Dose (DDD) of a drug by Excel VBA using the English name of the drug INN. Method: dynamically set the Web query string of Add method in Excel VBA Query Tables object by code, the variable is the INN English name of the drug, and automatically obtain the DDD value of the drug. Results: Using Excel VBA, DDD values of drugs can be easily and conveniently obtained. Moreover, DDDs and DDDs-related other medication indexes can be automatically calculated through the expansion of the code. Compared with manual operation, Efficient and accurate. Conclusion: It is practicable to use EXCEL VBA to automatically obtain DDD value of drugs, which improves the efficiency and accuracy of drug utilization analysis and has high practical value.