web scrapping

Good day All, I am new on this forum. I hope someone will be able to assist me. I have an excel document with a few Companies which I need to update pricing on products of a certain brand. To do this manually is a nightmare. Is there a way that I can put a URL for that certain brand in a cell...

I want the brand name to be extracted from a table, in a website in my excel sheet. There's this table which has information about the product's warranty, shipping and brand, which is under one single "div" element. So I'm unable to extract only the brand name, instead it extracts all the data...

Hi, I'm trying to write a VBA script for Web Scrapping. I have to select an item form a ListBox (********** tag in HTML) by its name. Does anybody know how to do this? I'm using this libraries: 1. Microsoft Internet Controls 2. HTML Object Library Here you have some of the HTML code...

Hi everyone, I have been working on a code which I want to use to extract data from YouTube music video channels (such as: https://www.youtube.com/user/RihannaVEVO/about). The data I would like to extract is: 1. Number of subscribers 2. Number of views In the code below, I have entered a...

Hi everyone, The following web site lists 63 products (fragrances): Dolce&Gabbana Perfumes And Colognes Using VBA, I would like to extract all the links to each of the 63 products in an excel file. An example of an outcome would be: /perfume/Dolce-Gabbana/Dolce-Gabbana-Pour-Homme-15336.html...

Hi everyone, I am interested in extracting the 2 "Longevity" and "Sillage" tables from the link below in excel using VBA: Burberry Brit for Men Burberry cologne - a fragrance for men 2004 Currently, I am able to do so using the following code: Longevity =...

Trying to pull weather forecast using https://www.wunderground.com/cgi-bin/findweather/getForecast?. I would like to pull the future high forecast for upcoming dates. I am having troubling pulling the table, does anyone have any advice for me? Code is posted below. Sub Weather_Scrape() Dim...