I am trying to scrape the price of an item from an online platform. The macro works perfectly for the item I record it for. However, when I edit the name of the item for the search query, it starts to throw an exception claiming it cannot find the item. I’m not sure what I need to change to make sure that does not happen. I’m basically trying to create something that I can put within a for loop, feed it the product name and have it fetch the price. I am using lazada.sg for this. I tried using amazon but ran into all sorts of issues with anchors. I’ve attached my file if someone could please take a look and help me out.
Price Scraping.xaml (11.5 KB)