Forum Discussion
What causes this process of extracting webpage data run so slow?
Deleted Perhaps you are trying to re-invent the wheel. Excel has a very powerful tool built-in called PowerQuery. Among many sources, it can connect to web pages though it depends on how these are built. Which page are you connecting to?
Hello, but I don't think so Riny_van_Eekelen. I searched on the internet and came to this solution. The website is an an online directory you search for businesses. The macro takes in a query string, generated a URL using that (to be able to get the whole results you need to be logged in). Then the page provides results (with pagination). I'm not just trying to open a webpage and download a simple table. I need to get data from each result some of which are in hidden menus (i.e. you need to click on a button) so I need to look for particular HTML elements in each shown result's data structure and get their innerHTML. Now it works and it's only a matter of speed. Do you think the powerQuery would help?
Deleted Can't tell? Which site? Can you give an example of a search string and the end result it should produce?