【摘要】 目的:利用Excel VBA,通过药物INN英文名实现自动获取药物的限定日剂量(Defined Daily Dose,DDD)。方法:通过代码动态设置Excel VBA Query Tables对象中Add方法的Web查询字符串,变量为药物INN英文名,实现自动获取药物的DDD值。结果:利用Excel VBA能简便的实现自动获取药物的DDD值,并且通过对代码的扩展,可实现自动计算药物的用药频度(DDDs)以及与DDDs相关的其他用药指标,较人工操作简便、快捷、高效及准确。结论:利用EXCEL VBA自动获取药物DDD值切实可行,提高了药物利用分析的效率和准确性,具有较高的实际应用价值。更多还原

【Abstract】 Objective: By using the Excel VBA,to automatically achieve the defined daily dose of the drug from the INN. Methods:Set Web Query string variables of the Add method in Excel VBA Query Tables as the INN dynamically by using code,and obtain the DDD value automatically. Results: It is easy to use Excel VBA obtaining DDD value of the drugs. It is a simple,efficient and accurate method compared to the manual operation. Conclusions: Accessing DDD value automatically by using the Excel VBA is practicable. By extending the code,the defined daily doses( DDDs) and other indicators related to the DDDs could be automatically calculated. This method could improve the efficiency and accuracy of drug utilization analysis. It has a high value of application.更多还原