Getting Youtube Video View Count

[jtb1979]

Evening all.

I have a question that I'm not even sure is possible. I have seen similar or the same questions asked but I don't understand the answer or don't think its what i need so here goes.

Lets say I have a list in row a of links that link to various different YouTube videos.
These videos or channels aren't owned by me.
Can i use a script that will visit each page and pull the view count from each video and put it in row b?

Many thanks in advance.

[Leith Ross]

Hello jtb1979,

Welcome to the Forum!

Here is a macro that takes the URL as it's argument. It will return the count for the video.

Please Login or Register  to view this content.

[jtb1979]

Thanks that basically works.

Though I have a problem.

Because its a function it is always checking the links provided, meaning that Excel is crashing every minute due to it doing a lot of processing.
Is there a way I can only run it once, or stop it from constantly checking the links?

[Leith Ross]

Hello jtb1979,

Can you post an example of the data layout and how you are using the macro?

[jtb1979]

test.xlsm

That's very basic.

In my actual sheet I have (so far) 40 different videos I'm checking. The view counts are constantly being checked (well at least once a minute)

[Leith Ross]

Hello jtb1979,

I don't see in your workbook where the view counts are being checked each minute. Unless you are manually editing each cell, the UDF will not update the cell when the sheet is calculated.

[jtb1979]

So if I'm sorting a group of data that contains the function then it will update?

Because i did think that may be it.

[silverrain]

have been looking for this. thank you.

[silverrain]

I have been trying to find the way to refresh data but I don't know VB and macro so would you mind helping me about it?

[ownifier]

Hello, I took your code above and put it into visual basic editor in excel. I don't know what to do next. I don't know much about VB, please help.

I want to take up to 50 links in an excel and get their view counts.

- Could I make this work? https://halgatewood.com/php-get-tota...-youtube-views

[Leith Ross]

Hello ownifie,

Do you have a sample of the worksheet I can work with?

[ownifier]

Yes here is what I am working with. https://www.dropbox.com/s/0j6ril2a1t...test.xlsx?dl=0

[Leith Ross]

Hello ownifier,

The attached workbook contains the macro shown below. I added a button to the "Videos" sheet to run the macro. If you need to interrupt the macro use CTRL+Break.

Please Login or Register  to view this content.

[ownifier]

Thank you so much for your help!

I received an error when I clicked "update" http://prntscr.com/7pk4g8

[Leith Ross]

Hello ownifier,

Sorry to be the bearer of bad news. Apple's version of Office does not support MSXML automation. This can only be run on a PC version of Office.

[ownifier]

Thanks Leith Ross!! It almost did the whole document. Here is the completed document, I borrowed my mom's PC! Here is as far as it got: https://www.dropbox.com/s/i4ieft4h9j...%202.xlsm?dl=0

It missed one and missed the last bits.

If I add more videos to this excel, how do I make sure it keeps on working?

Is there a way to click choose starting cell (for the next month and the next month)?

[Thomas92]

Hi There,

Pretty useful macro;

However it stops at some point (memory issue?) and the values returned are including HTML, by example "91 186"
Would be a good improvement to upgrade the macro and remove any HTML code that may have be included in the value.

Thanks !

[Leith Ross]

Hello Thomas92,

I have added another macro which will correctly extract the text from any HTML element. This was written after the View Count macro.

Please Login or Register  to view this content.

[ownifier]

Thank you guys again! Thanks Leith Ross for writing another macro! I added it (on a PC) to another module and it didn't change the result. Here is what I did. I need a little advice on where to put the macro please.

https://www.dropbox.com/s/i4ieft4h9j...%202.xlsm?dl=0

[Leith Ross]

Hello ownifier,

Here is the updated workbook. I ran it once so you can see the results.

[ownifier]

Thanks again!! Your super helpful!

The version you sent me doesn't have N122-N129 filled out even when I run it. And when I re run it N12 has an ERROR0 - Unknown, and makes the spot empty. Do I need to install any plugins to make this work?

[JasperD]

Quite an elaborate function to get viewcounts by the way.
I haven't read the whole thread, but wouldn't this work too:

Please Login or Register  to view this content.

Works for me on =Viewcount(A1) where A1 contains https://www.youtube.com/watch?v=owUavO_aovM
Set reference to Microsoft HTML Object Library

[Leith Ross]

Hello ownifier,

Okay, I corrected that mistake. I had the macro stopping at the last Total line. It now goes down to the last entry in column "A".

Please Login or Register  to view this content.

[Thomas92]

Thanks a lot Leith!

you were very quick on this one ;-)
Will test it tomorrow at work as it doesn't run on my mac.

Thanks again for helping, will be very time saving!

best,

[Thomas92]

@JasperD, I gave it a try but doesn't work on my side.
Error here :

Please Login or Register  to view this content.

At least on my mac, will give it a shot on my pc tomorrow.

thanks!

[ownifier]

Read previous comment from Leith Ross about Mac error on page 1.

[ownifier]

Thanks again Leith Ross!!! I think that fix will help as we add more videos.

One thing I noticed is to get rid of the ERROR0 messages is to keep a consistent URL. The macro only works with example URL: https://www.youtube.com/watch?v=7RWEllqh5J0

It didn't work for N12 because the URL was: http://youtu.be/7RWEllqh5J0

It didn't work with N122-129 because the URL was http:// not the correct https://

Love it!!

I added 2 more videos to test it and it works wonderfully.

Here is the final document with all of the fixes: https://www.dropbox.com/s/h29f3umzat...inal.xlsm?dl=0

[Leith Ross]

Hello ownifier,

You're welcome.

[Thomas92]

Read previous comment from Leith Ross about Mac error on page 1.

I did, this is why I said I will try it on my PC ;-)

[2biggie]

In Jasper's code, it seems to have trouble with the undefined HTMLDocument class. How do I enable that?

[JasperD]

as said in my post:
Set reference to Microsoft HTML Object Library

In VBA area, go to tools -> references and select Microsoft HTML object library

If early binding causes the trouble, then replace:

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

But this doesn't take away the need for the reference.

[2biggie]

Thanks, works great on PC now. Does this shorter code work on Mac too? I tried adding that reference but it's not there for OSX. Any way to install or other code that might accomplish the same thing across platforms? Thx

[silverrain]

how can i do it getting comments number?