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?
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?
