Wow

[Von Pookie]

So for any one wanting to Download off YouTube here is some code.

I have an addon in Firefox that grabs the video automatically from the page when I click a button

 

[Ivan F Moala]

So for any one wanting to Download off YouTube here is some code.

I have an addon in Firefox that grabs the video automatically from the page when I click a button

whats the addon ? I have IE7, FireFox and Opera on my system so I could use this.

stil it was interesting looking for a way to DO THIS

 

[Von Pookie]

http://www.youtube.com/watch?v=_y04aLS4NbM

 

[Von Pookie]

whats the addon ? I have IE7, FireFox and Opera on my system so I could use this.

Download Helper. Here ya go:
https://addons.mozilla.org/en-US/firefox/addon/3006

 

[gsouza]

Ivan

You can do anything. I was in your sight that brought me here to get the code to download youtube. I get errors. I don't know why but, it happens alot. Maybe you can have a sample file. I really would love to make this work but I can't figure it out. Please Ivan Helpppp Meeeee

Set objIE = New InternetExplorer 'user-defined type not defined

READYSTATE_COMPLETE 'variable not defined.

Loop .loop without Do

Replace(strVideoUrl, "amp;", "", 1) 'Sub or Function not defined

strVideoUrl = "http://youtube.com/get_video?video_id=" & 'Replace(strVideoUrl, "amp;", "", 1) 'Syntax error.

 

[Ivan F Moala]

Re: Ivan

You can do anything. I was in your sight that brought me here to get the code to download youtube. I get errors. I don't know why but, it happens alot. Maybe you can have a sample file. I really would love to make this work but I can't figure it out. Please Ivan Helpppp Meeeee

Set objIE = New InternetExplorer 'user-defined type not defined

READYSTATE_COMPLETE 'variable not defined.

Loop .loop without Do

Replace(strVideoUrl, "amp;", "", 1) 'Sub or Function not defined

strVideoUrl = "http://youtube.com/get_video?video_id=" & 'Replace(strVideoUrl, "amp;", "", 1) 'Syntax error.

Hi gsouza

PM me, it's easier and I'll email the workbook ......

Basically you need a reference to

"Microsoft Internet Controls" = SHDOCVW.DLL
and
"Microsoft HTML Object Library" = MSHTML.tlb

Excel 2003 on Win XP

 

[Andrew Fergus]

Hi Kristy

Thanks very much for the link! When I grab copies of videos I (used) to go to http://keepvid.com/ and download the file in a flv format, which can be viewed using flv player. But if there is a firefox add-in that would be easier.

Cheers
Andrew

whats the addon ? I have IE7, FireFox and Opera on my system so I could use this.

Download Helper. Here ya go:
https://addons.mozilla.org/en-US/firefox/addon/3006

 

[iknowu99]

to avoid special flv player one can use winamp: DJ Egg explains: http://forums.winamp.com/showthread.php?postid=2013385

 

[Jon Peltier]

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:

    '// 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".

 

[Oorang]

Kristy.. Finally got around to watching it... I admit it's quite good, but I have to say... That is a sound that should NEVER come from a man.