Hi,
i am looking for a solution to extract information from a website but also pictures, photo's or other material like PDFs. Is it possible to do this in VBA ? And how do you store the data in excel. An other challenge is how to store the "non-data" as the pictures or PDFs in a structured way, so you can find it easy. A link in the sheet, a directory structure or something like that.
Hopefully, i can learn from you help and tips.
Thanks in advance,
Joepy
Hi Joepy,
There is no easy way to scrape a website with excel. If you have access to that site databases, you can extract data with power query.
If you want to explore the entire site, and navigate through pages to collect data, it's more complicated, every site has a different structure, and the code should handle each case, so it will be a long code :).
With vba, it's possible to open internet explorer and navigate through that site structure, but I prefer to use already made tools than writing such complex codes 🙂
There are some free tools, like import.io , but you have to learn how to use it. A professional tool is more powerful, but it's not free, of course.
Catalin
