I was using the GetElementByRegex function in the Scrape HTML AddIn with great success then one afternoon all the data started turning blank. I looked at other sites but was having the same issue. I think that it might only be pulling part of the HTML and not the complete page. Has anyone experienced this before? What was/is the fix?
I believe best is to debug the code. Be aware that there is a limit to the amount of text (characters) the code can return so if you are using the function to return the entire HTML it will crash.
Other scenario is the code cannot connect to the internet (maybe you are now working via a proxy server). You can use proxy but need to define the proxy server in the VBA object