Retrieving Product Pictures and Tabular Data from the Website

[erzurum]

Hello to everyone,

I have a few different websites, I want to extract data from them and then create data for my business and analyze.

Link Macro.xlsx

I am waiting for help from you dear wise people.

My demands.
1 - site (Pega Air Springs - PEGA Otomotiv A.S.)
Example link: Pega Air Springs - PEGA Otomotiv A.S.
It is very important that the Product Numbers, OEM Part No, Cross References and the names of the pictures of the products are the same as the product name.
2 - site (Product search)
Example: Product Search = Part No = RL9772
It is very important that the Product Numbers, OEM Part Number, Cross References and the names of the pictures of the products are the same as the product name.
3 - site (https://www.airspringapp.com)
Sample link: https://www.airspringapp.com/us/EMEA/Product/Airspring?idBalg=24627
It is very important that the numbers of the products, Original parts, Cross References and the names of the pictures of the products are the same with the product name.

We look forward to your support regarding the solution with Excel VBA.

 

[erzurum]

Hello there,

We look forward to your assistance.