I am new to VBA and I am trying to figure out how I can use VBA to fill out an online risk calculator using data from excel

[obu2024]

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:

1. Extract data from specific cells in Excel. (No clue how to do this for multiple different data sets)
2. Input this data into the corresponding fields in the web-based risk calculator.
3. Retrieve the calculated risk result back into Excel.

EDIT: Does not have to be on MacOS

 

[HighAndWilder]

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:

1. Extract data from specific cells in Excel. (No clue how to do this for multiple different data sets)
2. Input this data into the corresponding fields in the web-based risk calculator.
3. Retrieve the calculated risk result back into Excel.

View attachment 116958

EDIT: Does not have to be on MacOS

Would it not be easier to agree to the American Heart Association's PREVENT™ License Agreement and include the logic in an Excel spreadsheet?

Once we know the logic I'm sure that we can help you implement it.

 

[John_w]

Looks like that web page doesn't work with Internet Explorer - if it did the automation is more straightforward because standard Windows libraries can be used. Therefore you would need to install SeleniumBasic and a suitable web browser driver (I prefer EdgeDriver since Edge is now part of Windows) for VBA to fill in the web page form from Excel cells and retrieve the calculated result to Excel.