Consulting

Results 1 to 8 of 8

Thread: testing how to embed a video

  1. #1
    Knowledge Base Approver VBAX Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,902

    testing how to embed a video

    let's try flv first:
    https://www.dropbox.com/s/hgk18oltwj...tled5.flv?dl=0

    and now mp4:
    https://www.dropbox.com/s/gel0dg7xad...edia1.mp4?dl=0
    let's see...

    Well that only gave a link. I was hoping by putting the url within video tags it would be playable in situ.

  2. #2
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    7,006
    Location
    You trying to play this in a userform?
    Paul

    ------------------------------------------------------------------------------------------------------------------------
    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s)
    (multiple files can be selected while holding Ctrl key) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  3. #3
    Knowledge Base Approver VBAX Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,902
    No, just in a post in a regular thread: msg#7 in this thread: http://www.vbaexpress.com/forum/show...ox-on-userform
    p45cal - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
    If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  4. #4
    Knowledge Base Approver VBAX Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,902
    Trying XL2BB from MrExcel here:
    [RANGE=cls:xl2bb-100][XR][XH=cs:5]xl2bb.xlam[/XH][/XR][XR][XH][/XH][XH=w:207.75]A[/XH][XH=w:107.25]B[/XH][XH=w:51]C[/XH][XH=w:164.25]D[/XH][/XR][XR][XH=ch:21]1[/XH][XD=fw:b|cls:bb][/XD][XD=fw:b][/XD][XD=fw:b][/XD][XD=h:l|fw:b|fz:16pt]7A-7P DAILY STAFFING[/XD][/XR][XR][XH=ch:18.75]2[/XH][XD=h:c|fw:b|fz:14pt|cls:bt bb]2 MED/SURG[/XD][XD=h:c|fw:b|fz:14pt|cls:bb]3 MED/SURG[/XD][XD=h:c|fw:b|fz:14pt|cls:bb]ED[/XD][XD=h:c|fw:b|fz:14pt|cls:bb]FLOAT POOL[/XD][/XR][XR][XH=ch:18.75]3[/XH][XD=h:c|fw:b|bc:E2EFDA|fz:14pt|cls:bt]29/09/2019[/XD][XD=h:c|fw:b|cls:bt][/XD][XD=h:c|fw:b|cls:bt][/XD][XD=h:c|fw:b|cls:bt][/XD][/XR][XR][XH=ch:15]4[/XH][XD=h:c|fw:b|fz:11pt]CN[/XD][XD=h:c|fw:b|fz:11pt]CN[/XD][XD=h:c|fw:b|fz:11pt]CN[/XD][XD=h:c|fw:b|fz:11pt]RN[/XD][/XR][XR][XH=ch:15]5[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]6[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]7[/XH][XD=h:c|fw:b|fz:11pt]RN[/XD][XD=h:c|fw:b|fz:11pt]RN[/XD][XD=h:c|fw:b|fz:11pt]RN[/XD][XD=h:l][/XD][/XR][XR][XH=ch:15]8[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]Joe[/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN17[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]9[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]Jack[/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN18[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]10[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]Jane[/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN20[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]11[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN23[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]12[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]13[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]14[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]15[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]16[/XH][XD=h:c|fw:b|fz:11pt]LPN[/XD][XD=h:c|fw:b|fz:11pt]LPN[/XD][XD=h:c|fw:b][/XD][XD=h:c|fw:b][/XD][/XR][XR][XH=cs:5][RANGE][XR][XD]Housewide[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE][RANGE=cls:xl2bb-extra-100][XR][XH=cs:3]Cell Formulas[/XH][/XR][XR][XH]Range(s)[/XH][XH=cs:2]Formula[/XH][/XR][XR][XD]A8:A15[/XD][XD]A8[/XD][XD]{=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0,MATCH($ A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}[/XD][/XR][XR][XD]B8:B15[/XD][XD]B8[/XD][XD]{=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0,MATCH($ A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}[/XD][/XR][XR][XD=cs:3|p:5|fz:0.85em]Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.[/XD][/XR][/RANGE]
    Last edited by p45cal; 12-23-2019 at 05:21 AM.

  5. #5
    Knowledge Base Approver VBAX Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,902
    Well that failed!

  6. #6
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    7,006
    Location
    I think you're out of luck to have a video play in situ


    https://www.dropbox.com/s/hnzrl4wetq...32-18.mkv?dl=0


    Advanced has the Insert Video icon, but all it really does is insert [ video ] .... url .... [ /video ] tags

    [VIDEO]https://www.dropbox.com/s/hnzrl4wetqefmco/2019-12-17%2011-32-18.mkv?dl=0[/VIDEO]
    Paul

    ------------------------------------------------------------------------------------------------------------------------
    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s)
    (multiple files can be selected while holding Ctrl key) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  7. #7
    Knowledge Base Approver VBAX Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,902
    Reluctantly, that's the same conclusion I reached; I was hoping the play button and message would be in the vbax message and the video play without going to another site.
    p45cal - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
    If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  8. #8
    Knowledge Base Approver VBAX Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,902
    Testing same with an animated gif (copied from Marc L at chandoo https://chandoo.org/forum/threads/mo...-folder.33971/ ):
    insert image:

    and video:
    http://perso.numericable.fr/mpl/pic/DClickFolder.gif
    p45cal - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
    If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Posting Permissions

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