I’m looking for some assistance with a VBA code that can use data from an Excel spreadsheet to automatically fill out the fields in the ASCVD Risk Calculator found at this link. The idea is to streamline the process of entering patient data into the calculator directly from the spreadsheet.
The data I have includes common fields such as age, cholesterol levels, blood pressure, and other relevant health information. I'd like the VBA script to:
EDIT: Does not have to be on MacOS
The data I have includes common fields such as age, cholesterol levels, blood pressure, and other relevant health information. I'd like the VBA script to:
- Extract data from specific cells in Excel. (No clue how to do this for multiple different data sets)
- Input this data into the corresponding fields in the web-based risk calculator.
- Retrieve the calculated risk result back into Excel.
EDIT: Does not have to be on MacOS
Last edited by a moderator: