You are reading a single comment by @chez_jay and its replies.
Click here to read the full conversation.
-
Web scraping is inherently a bodge, and doing it in Excel even more so.
Yes it can work, but if you need reliability you should be querying an API.
If you need to scrape, there are better ways, for example a Python script that more specifically targets the values you need, and alerts you if it can't find them, or doesn't give you what is expected.
chez_jay
Gave this ago today. There was two sections to the page, rates that were already there and rates that I’d chosen options for.
Excel picked out the ones that were already there, but not the ones I’d chosen tick boxes for????