VBA Macro to input values into web form and then click button and get results back

Good Day all,

I've attached an HTML file that I use to built shift patterns. What I want to do is run an excel macro that grabs values from 7 cells, uses those values to fill in the 7 boxes on the webpage. Clicks one of the buttons (defined by the user) and grabs the resulting chart and puts it back into excel and closes the webpage.

I know that it can be done, but I don't even know where to start with it.

Preferably, I'd like it to be done entirely in the background, all I care about seeing is the resulting chart.

Any help would be appreciated.

(I had to zip the file as it wouldn't allow me to upload an html file)

Thanks,
Chris