Wow

:LOL: Yeah, I think my little video link got swallowed up by all the download posts. But, oh well.

I have no clue what he's singing, but I do like it. I have an mp3 of it :LOL:
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
I had a problem with Ivan's code. This line:

PosLastID = InStr(1, strCode, "&sk=")

returned 0 for PosLastID, because "&sk=" isn't present in the innerHTML of the page (I checked). Instead I used this:

Code:
    '// Find position of VideoID
    PosVideoID = InStr(1, strCode, "amp;video_id")
    
    '// Find position of end of videoID
    PosLastID = InStr(PosVideoID, strCode, "&")

and eventually I got a strVideoURL of
http://youtube.com/get_video?video_id=7SJGDG5GZ2c

but I got an error message that IE couldn't download the video from youtube. Does this look like the right form of strVideoURL?

Note: clicking on the link above to strVideoURL led to "HTTP 404 Not Found".

John
Sorry.......
That code was admittedly a quick hack. I am currently looking @ a more robust way. What happens is the Tag changes for each logon session, also using innerhtml doesn't always give you the correct ID. The way I'm doing it now is through Microsoft.XMLHTTP as this will yield the source code and the actual script function that you can get the IDs such as VideoID, Tag and Length. I will post to my site when finished.

appologies to all who tried that code.... worked 1st time :) BUT then I tested and found you need to get the IDs from the source code which HTML coding via IE will not yeild.


EDIT:
OK, updated the code to my site

Workbook here http://www.xcelfiles.com/YouTube.html
 
Keep up the subthread. Everything you do is amazing, Ivan. But back to Andrew's gist,

I could ruin your productive lives by listing one-tenth of the "IMHO" amazing youtubes I've seen - on music alone. So only as a service to those of you who cannot cross the "opera dude" barrier (and I'm not a fan, but Andrew that really did move me) - presented is the far end of the spectrum. This is loud, heavy rock music and is long. I cannot be responsible for any resultant brain damage.
"Awesome guitar solo by great Van Halen tribute band ERUPTION's Al Estrada"
http://www.youtube.com/watch?v=ocabgZ-QVUU&mode=related&search=

Well okay, here's a higher-brow alternative, one of many guitar tapping examples -
Guitar "Tapping Genius"
http://www.youtube.com/watch?v=JO2ztfUdRo4

Oh, wait, those aren't vocalists. If you have had your diarrheal medication today, or conversely unblinkingly worship the One True Shatner,
"William Shatner sings Taxi on Dinah!"
http://www.youtube.com/watch?v=dBWOmHUvKBw&mode=related&search=
I cannot be responsible for any mental or excretional damages attributed to viewing this material.
 
I suppose the thing with Paul Potts was his relative state of obscurity and he had this talent which was 'discovered'. I see he has now released a CD.

Anyhoo....on the subject of cringeful music videos, I'm about to steal some of your time with the legendary 'Hooked on a Feeling' video from David Hasselhoff : http://www.youtube.com/watch?v=PJQVlVHsFF8

If you are a Shatner fan then you might want to search YouTube for "Lucy in the sky with diamonds". Beam me up Scotty.......

Andrew
 

Forum statistics

Threads
1,214,935
Messages
6,122,337
Members
449,077
Latest member
Jocksteriom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top