+ Reply to Thread
Results 1 to 15 of 15

Embed YouTube video into an Excel spreadsheet

  1. #1
    Registered User
    Join Date
    07-27-2012
    Location
    Gothenburg, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    5

    Embed YouTube video into an Excel spreadsheet

    This is something I have started to use a lot when I have my Excel courses or in my class when I teach Excel to students at my business school.
    I embed YouTube-videos into the excel spreadsheet. This makes it possible for the user of the spreadsheet to watch the video at the same time as he/she is working in the Excel sheet.

    The participants at my courses love it! After two days of “cramming” they have all or exercises in 5 to 10 minutes video clips to bring embedded in the exercise workbooks.

    For my students the get video recorded Excel solutions to advanced prpoblems.
    OK, this is how you do it:

    1. You insert a Shockwave Flash Object in an Excel spreadsheet (Developer ->Insert-> More controls)

    2. In the properties for that object you add an address to you YouTube-movie.

    3- You need to do some small changes to the YouTube address (Delete the watch? And replace = with a /). Eg: making:

    http://www.youtube.com/v/bvgttKEIhFc&feature=relmfu
    out of
    http://www.youtube.com/watch?v=bvgtt...feature=relmfu

    After that you have an emedded youtube video in your Excel spread sheet.

    If you want more details, you can read my blog post on this, where I also have a video demonstrating everything step by step…

    You find it here:
    http://excelblogger.com/embed-youtub...l-spreadsheet/

    Regards
    Anders

    excelblogger.com
    Last edited by excelblogger; 08-11-2012 at 11:47 AM.

  2. #2
    Registered User
    Join Date
    08-07-2012
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Embed YouTube video into an Excel spreadsheet

    This is fantastic!!

    I have 2 questions for you, to polish this up for my needs

    1. How can you stop the video? Or prevent the video from further loading in the background when pause is pressed?

    2. How can you start the video at a specific time? I have tried the http://www.youtube.com/v/123456ens&f...tailpage#t=11s method, but it still starts from the beggining. On the same note, not only is it possible to start from a certain time, but can you stop the video automatically at a certain time? ie have a range to play from?

  3. #3
    Registered User
    Join Date
    07-27-2012
    Location
    Gothenburg, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Embed YouTube video into an Excel spreadsheet

    Thanks for positive feedback,

    I understand what you are looking for, and I would like to do it myself…

    I have only manage to make the video start after a certain part of the video by adding “&start=100” after the address.
    e.g. this code will make the video start after 100 seconds:

    http://www.youtube.com/v/bZzN1LGeAc8&start=100

    But I haven’t manage to add an &end code that works.

    An alternative solution might to tweak the code from places such as http://www.tubechop.com/ that helps you cut out pieces from youtube-movies. But I haven’t managed to figure it out how to do that. If you manage, please let me know.

    Maybe there is a possibility to change other parts of the Shockwave Flash Object properties to make it work better. But that’s beyond my present knowledge…

    I have no solution to the “further loading” problem.. yet…

    With the hope that someone else can solve the problem…

    / excelblogger.com

    http://excelblogger.com/embed-youtub...l-spreadsheet/

  4. #4
    Registered User
    Join Date
    11-16-2011
    Location
    San Diego, California
    MS-Off Ver
    2007
    Posts
    78

    Re: Embed YouTube video into an Excel spreadsheet

    This is excellent and exactly what I've been looking for to do instructions for use on a file I've created.

    Is it possible to embed the video in a userform etc so the user can perform actions on different tabs file while the video is playing?
    Last edited by WorldBridge; 09-05-2012 at 07:58 PM.

  5. #5
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Embed YouTube video into an Excel spreadsheet

    You can easily accomplish this with a web browser embedded in the userform.

    abousetta
    Attached Files Attached Files
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  6. #6
    Registered User
    Join Date
    08-31-2012
    Location
    Andromeda, Hawaii
    MS-Off Ver
    Excel 97/2003 and 5.0/97
    Posts
    49

    Re: Embed YouTube video into an Excel spreadsheet

    this amazing abousetta! thanks

  7. #7
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Embed YouTube video into an Excel spreadsheet

    Glad you liked it. Some people have done some amazing things with the web browser in a userform including showing images, different cell contents, etc. (especially when used with Excel's camera feature).

    Good luck.

    abousetta

  8. #8
    Registered User
    Join Date
    11-16-2011
    Location
    San Diego, California
    MS-Off Ver
    2007
    Posts
    78

    Re: Embed YouTube video into an Excel spreadsheet

    Thanks a ton abousetta! That is exactly what I needed.

    I know I can copy and paste the userform you created in the file but could you describe briefly how to do this myself?
    Or point me in the right direction?

  9. #9
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Embed YouTube video into an Excel spreadsheet

    It is as simple as adding anything to a userform (e.g. textbox, picture, etc.). Right click in the userform's toolbox (the popup menu that has all the objects you can add to a userform) >> additional controls >> Microsoft Web Browser. A small little globe icon will appear along with all the standard objects you can use. Just click on it and use it as you would any other object. The most basic command as you can see from my example is to navigate to a site, but you can also set up buttons to send you to the default home page on IE, back, etc. as you would in IE.

    abousetta

  10. #10
    Registered User
    Join Date
    11-16-2011
    Location
    San Diego, California
    MS-Off Ver
    2007
    Posts
    78

    Re: Embed YouTube video into an Excel spreadsheet

    I don't see 'additional controls' in the userform's toolbox...

    I can see it in the Excel ribbon Developer >> Controls >> Insert
    but where can I find it in Visual Basic? Is it missing because I have 2007?

  11. #11
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Embed YouTube video into an Excel spreadsheet

    The 'additional controls' option only appear when your right click in the empty space in the toolbox (not the ribbon).

    abousetta
    Attached Images Attached Images    

  12. #12
    Registered User
    Join Date
    11-16-2011
    Location
    San Diego, California
    MS-Off Ver
    2007
    Posts
    78

    Re: Embed YouTube video into an Excel spreadsheet

    AHA! Thanks a ton!

    Now I have one last problem and let me know id I need to start a new thread for this:
    I want this userform to be visible while allowing the user to perform actions like click buttons, change sheets, and run macros.

    Can the video userform be run on a different thread or am I thinking too much like Java?

  13. #13
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Embed YouTube video into an Excel spreadsheet

    Here's an example showing two userforms that will pop up and each will not interfere with the other nor will they interfere with work on the worksheets. The secret is using DoEvents to pause the looping code and to load the userforms as vbmodeless (default is mode).

    abousetta
    Attached Files Attached Files

  14. #14
    Registered User
    Join Date
    11-16-2011
    Location
    San Diego, California
    MS-Off Ver
    2007
    Posts
    78

    Re: Embed YouTube video into an Excel spreadsheet

    Perfect. I can now take over the world! MUAHAHAHAHA

    Thank you, you're help has been exceptional.

    Out of curiosity: what does modeless vs mode do?

  15. #15
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Embed YouTube video into an Excel spreadsheet

    If the userform is mode then it will be like a msgbox. You can't do anything in Excel or any other userform while the original userform (mode) is visible. Modeless allows you to interact with other Excel objects (e.g. worksheet) while the userform is loaded and visible.

    Hope this helps.

    abousetta

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1