Excel VBA Forms Part 16 - Playing YouTube Videos

[@imranbhatti8580]

It is the best tutorial series on Userform. The tutorials I have searched on the youtube so far are , I think not equivalent to this series. WiseOwl covered all the userform controls one by one in every tutorial. Since my internet speed is not so good. I had to download every video in order to watch it without buffering. I think this series should not be stopped .It should cover the rest of the controls as well in future.......I will be waiting.....Thanks Andrew , Infact the whole of of wiseowl....keep it up.

[@krn14242]

Thanks Andrew. Great series thus far. I have learned a lot from these. You are a great instructor.

[@divyal5852]

Thank you so much Andrew! Just when I was thinking I finished all the VBA Videos..was feeling a lil sad till I actually came across the new set of WiseOwl videos on useforms..You're a great instructor as you always make a mention of what could go wrong.. Learnt a lot through these videos and this one on youtube is beyond being great!

[@kumar-manoj]

just wow sir! Thanks again

[@WiseOwlTutorials]

My pleasure Manoj, glad you enjoyed it!

[@ricardosantos7884]

Very cool !!! I've never seen advanced controls like these !!! Thank you for this series about forms, I've found very useful !!!

[@donbogdala5428]

Okay, I just finished the whole series on userforms! The timing of the release of these videos couldn't have been anymore perfect since I have been working on userforms lately at work. Just WOW! Thank you for the time that you put in to these tutorials! Please don't stop! I was wondering if it is possible to use the form to scroll through the data set to review or edit any existing data? That would be awesome! As always, Wiseowl has the best tutorials! Waiting patiently for the next one!

[@SlugBrazil]

Very good tutorial teacher! Thanks!

[@yosef-yosef9414]

Thank you SO much for this video

[@forzaalgiers2045]

Thank you for the great effort and the videos. I just wish the videos were a bit Wider. Thank you again

[@daniellickteig8239]

Love these videos. I'm sorry you put so much time into this video and it is no longer an option. I haven't searched your site, yet, but isa solution the "WebBrowser" control?

[@WiseOwlTutorials]

Thank you Daniel! Such is life I suppose 😀 That's a great suggestion, and yes, it certainly works with a bit of relatively simple code like so: With Me.WebBrowser1 .TheaterMode = True .Navigate "kzbin.info/www/bejne/r2jciH9mpKh1ac0" End With We could also use the Windows Media Player control but I think that might only work for local files, not streaming video. Thank you for the suggestion!

[@daniellickteig8239]

@@WiseOwlTutorials This is fascinating to me!! I never thought about Windows Media Player inside of Excel. I have used iTunes, because it is already built, but I think I would like a more robust Audio player database/player where you can click a link to find more information on an artist or recording.

[@WiseOwlTutorials]

@@daniellickteig8239 Sounds like a fun project! Some basic code would look like this: With Me.WindowsMediaPlayer1 .settings.autoStart = True .Url = "C:\Wise Owl\My Video.mp4" End With And here's some documentation which might help docs.microsoft.com/en-us/windows/win32/wmp/player-object-model-for-scripting-languages docs.microsoft.com/en-us/windows/win32/wmp/player-object Good luck!

[@luismorana5072]

Buona sera Andrew, Delighted with your tutorials. Great as usual. Thank you for your efforts. I actually learnt a lot with the first set of VBA tutorials and this set of UserForms is awesome. I would like you to consider a tutorial that will actually help me and will help (hopefully) your fans as well. I downloaded MS SQL 2014 server express and would like to use Excel VBA Userform to make an manage a DB for books in my local school. I am helping a local library at school and here are a lot of books to load in the DB that will have to be managed. I was told that MS Access is not very reliable if you look for remote connection to a DB and it was recommended to work with MS SQL for a more robust application. I will have to find out how to connect remotely to the server but first would like to know more on how to connect to a local sql using VBA. Hope this sounds interesting and may be considered for future tutorials. Grazie. Luis.

[@luismorana5072]

+WiseOwlTutorials Thank you Andrew.

[@zacksmith3171]

Thanks for this wonderful series. I have been following along since the beginning but have recently faced a problem. The *KZbin.com/v/video_id* does not work anymore, I tried *KZbin.com/embed/video_id* instead but still it did not load the video. Any suggestions?

[@grigoriefimovic1547]

Hi Andrew...i'd love to do same with windows media player inside userform but i'm not able to get the media player to behave the way i'd love. It' s re-sizing automatically plus i can't get say a list of songs or movies to load in the playlist. Any luck??? Woudl apppreciate, thanks.

[@philmillington5025]

Hi Andrew Just been reading up Adobe Flash Player and realise what the problem was sorry to have trouble you ps… is there a fix for this part of the course Regards Phil

[@WiseOwlTutorials]

Hi Phil, no problem ( I don't see any other messages from you on this video). Unfortunately there isn't a replacement for this technique. The fairly unsatisfactory workaround that I've used to embed a web browser control and set the URL to the KZbin video but it's clunky. I suspect this may not work for much longer either as I seem to recall the web browser is based on IE. Sorry about that!

[@ВячеславАнтонов-п3в]

Красавчик!, Thanks... Good tutorials!!!!

[@gillesberthon963]

Hello dear friends, KZbin now uses HTML5 video as standard in Chrome (my navigator) because they dropped Flash in favor of HTML5 as default web player. Of course the wonderful video above that I used with great pleasure is no longer useful as everytime I try an URL in the 'Trailer' page I get in my trailer window the following message : Flash-embedded videos are no longer supported... but you can still watch this video on You Tube... Which is exactly the opposite of what I wanted to do... Is there any possibility to do the same as before with using HTML 5 instead of Shockwave Player ? It was so great to play KZbin videos on Excel !!! Thanks in advance for any suggestion.

[@gillesberthon963]

Thanks for your help. Unfortunatelly my dream movie database showing the trailers has sunk !!! Best regards and "bravo" for you excellent work.

[@isheludko]

@@gillesberthon963 Just thinking: VLC can play youtube videos, just on pasting the link in it. So in your database, you could ask VBA to open VLC and play the video from the link automatically.

[@TheSardOz]

Will the end user be able to play the video if doesn’t have the same player installed? Thank you Andrew!

[@WiseOwlTutorials]

Hi there! Sadly this technique doesn't work any more as the Shockwave Flash Player control is no longer supported by KZbin.

[@RohanK]

Thank you very much :)

[@wattjock2405]

Okay, just an FYI... I am late in this series and have just now gotten to this video in 2021. I have found that Adobe no longer supports the Flash Player, it's EOL being Dec of 2020. I'll still complete the video though, thinking maybe I can find a work around; perhaps Windows Media Player...?

[@WiseOwlTutorials]

Yeah it's super annoying and I don't know of a workaround for this. The Windows Media Player control is great for video files which you have saved locally but I don't think that you can make it reference a KZbin video. Let me know if you find out how though!

[@benjaminfaulkner1376]

when i try to add the flash player control it comes up with the error message: Access denied. Is there a solution for this error?

[@MarcoSebastiani83]

same here...can't find anything online to fix it

[@KhalilYasser]

Flash-embedded videos are no longer supported. Is there a solution for this problem Andrew?

[@WiseOwlTutorials]

Hi Yasser, there isn't a solution that I'm aware of unfortunately, kind of annoying after making the video!

[@KhalilYasser]

@@WiseOwlTutorials Thanks a lot for reply. This seems frustrating problems (to not no longer support some features)

[@WiseOwlTutorials]

It is frustrating! But it's the price of progress I suppose!

[@trdn1]

Wait a minute, wait a minute...Owl...uh...are you telling me that you built a video player out of a userform?!?!?

[@trdn1]

Def cool...again, thank you. I'm the office hero with my little VBA based grade sheet generator built on your vids.

[@NA80121]

Can you upload asp.net tutorials please?

[@phoenixrising2645]

Great Video, however I am having a problem doing this and maybe you can help. The url of the video I want to play is kzbin.info/www/bejne/bp3RnIhvqdN8pK8 so I change it to kzbin.info/www/bejne/bp3RnIhvqdN8pK8 as you described, then when browsing to that url, KZbin returns "his page isn't available. Sorry about that. Try searching for something else." Am I doing something wrong??