Web page in excel

username90

New Member
Joined
Aug 4, 2015
Messages
1
Is it possible to pull data from an interactive map on a webpage into excel?

this is the website: UK Sustainable Drainage

Id like an excel sheet to have a form with the websites map on it. Then the user can select their location on the map and it will produce the "m5-60" and ""r" Ratio" Map Values (found further down on the website) into two excel cells.

The other easier option is to make a form with the whole website on it and have the user get the values themselves. The sheet will be used for other various calculations that use those two map values, so even if the user has to retrieve the values themselves I'd still like the sheet to open up the website.

Im new to coding so this is a bit much for me. Is there a code I can use for this? Either option?

Also when I try to insert ActiveX Control>Microsoft web browser form I get a "cannot insert object" error. Is there a fix for that?
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,136,288
Messages
5,674,867
Members
419,530
Latest member
undisclosed

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top