Import some data and files+photos from website (with subpages) to excel

Hello,
I want to import some data of products (ca. 4500 products) from website: cakesupplieseurope.com
For e.g. cakesupplieseurope.com/en_gl/wilton-jumbo-sprinkles--heart--56g-03-2533
And I want import to excel these data: take.ms/tqhPh
So the main is import data + (if vba can do it) download all photos and files to 2 folders on my computer.
Could some1 help me with this issue?
Thank you in advance for your reply.

Hi there,

you should look around for other programs to do the mining for you.
I once have used a program which could get data from websites that you Pick by selecting them.

here is a link I found, worth a shot. (might have used this exact program)

https://www.parsehub.com/blog/scrape-images-website/

also there is alot of info about scraping with google sheets.
Using VBA to webscrape is a veryvery no.no.

greetings!