Scrape website HTML - VBA (music industry)

[viktor4e]

Hi everyone,

I am working on a project that requires extracting music industry data from YouTube.
Specifically, I need to extract number of subscribers and number of views data from channels such as this one:
https://www.youtube.com/user/VEVO/about

I tried doing this with the "Get Data-From Web" option in excel, but it does not work as there is no table to be selected.

Ideally, I would like to list a lot of channels in excel, and a macro to loop through each and extract the data
for each channel in the same excel file. I have started on a code, but as I am a beginner, I have not gone very far:

Sub Macro1()
Set objIE = CreateObject("InternetExplorer.Application")
objIE.Top = 0
objIE.Left = 0
objIE.Width = 800
objIE.Height = 600
objIE.Visible = True
objIE.Navigate ("https://www.youtube.com.com")
Do
DoEvents
Loop Until objIE.readystate = 4
End Sub

Any assistance in resolving this matter would be greatly appreciated.
Many thanks in advance.

 

[John_w]

It looks like you can extract the data using getElementsByClassName, so try something like:

MsgBox objIE.document.getElementsByClassName("about-stats")(0)

Please use CODE tags.