I am working in Excel 2007. I want to click on something and get an external
video to play, from a defined starting point to a defined ending point.
Hyperlinks have worked great for getting the whole thing to run, but I
haven't been able to figure out how to get them to give me the start/stop
point. I would be happy to use macros. Thank you in advance for any help.

Where is the file located? A hyperlink could be on a local pc as a
file, it could be imbedded in another document, it could be on the
web!!!!


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176787

Microsoft Office Help

Hello Joel,

Thanks for responding. I am not sure how it matters and I could potentially
move them. Currently, the videos are located in a directory directly below
the Excel file that I am working in.

"joel" wrote:


Where is the file located? A hyperlink could be on a local pc as a
file, it could be imbedded in another document, it could be on the
web!!!!


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176787

Microsoft Office Help

.

The only way I believe it can be done is through a DLL. Depending on
the player you are using there is a DLL on you PC. For example the
windows player would be in the c:\windows folder. You can define the
Library call to any of the DLL entry points. I haven't done this my
selef but did find websites with examples. any example in C Language or
VB 6 using the dll can be converted to VBA.

Another approach would be to build a webpage with the controls. Then
from VBA using an IE explorer application access the webpage. Ive had
people ask me how to run java scripts in VBA and my answer was to create
a webpage. So if you find any Java code then it could be put into a
webpage.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176787

Microsoft Office Help

Joel,

Thanks for your responses. I have learned about putting a WMP onto a
userform, initiating a video with a shell, and playing a sound. I have found
quite a bit about commands using Jave script, which seem to have the
functionallity I need and more. I may ultimately need to learn more about
this and follow your suggestion regarding a webpage.

I am suprised that such a simple thing is not possible to do. Any further
words of wisdom would be welcome.

Thanks again.
"joel" wrote:


The only way I believe it can be done is through a DLL. Depending on
the player you are using there is a DLL on you PC. For example the
windows player would be in the c:\windows folder. You can define the
Library call to any of the DLL entry points. I haven't done this my
selef but did find websites with examples. any example in C Language or
VB 6 using the dll can be converted to VBA.

Another approach would be to build a webpage with the controls. Then
from VBA using an IE explorer application access the webpage. Ive had
people ask me how to run java scripts in VBA and my answer was to create
a webpage. So if you find any Java code then it could be put into a
webpage.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176787

Microsoft Office Help

.

I've given up trying to use the Wijndows Media Player from VBA. I
didn't find much info on the web the last time I attempteed to program
the media player. I tried finding the DLL but there were a few
different DLL and the commands went well documented. People wanted to
get the music libraries into excel and I gave up.


VBA is really meant to be used by office products and other
functionality is there using the windos dll but it is not well
documented except for the web forums. You can get to a lot of features
using the VBA Reference libraries (menu tools - Reference). but you have
to know which function is in which library which isn't always easy to
find. Most of the experts learned using C lanaguage and adapted their C
Language expertese to VBA.

Microsoft compilers (Basic and C) have the libraries better documented
but the compilers still use the windos Dll just like VBA.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176787

Microsoft Office Help

Hello Joel,

Thanks again for your support on this. Lamely, my ultimate solution might
just be putting the start and stop times in the UserForm caption, and let the
user deal with it.

"joel" wrote:


I've given up trying to use the Wijndows Media Player from VBA. I
didn't find much info on the web the last time I attempteed to program
the media player. I tried finding the DLL but there were a few
different DLL and the commands went well documented. People wanted to
get the music libraries into excel and I gave up.


VBA is really meant to be used by office products and other
functionality is there using the windos dll but it is not well
documented except for the web forums. You can get to a lot of features
using the VBA Reference libraries (menu tools - Reference). but you have
to know which function is in which library which isn't always easy to
find. Most of the experts learned using C lanaguage and adapted their C
Language expertese to VBA.

Microsoft compilers (Basic and C) have the libraries better documented
but the compilers still use the windos Dll just like VBA.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176787

Microsoft Office Help

.

Hello Joel,

I decided to be stubborn and it payed off to some extent. I now have the
following code for running an embedded Windows Media Player on a userform.
It actually starts where I want it to!

Dim MyStart As Long
MyStart = 30 'This seems to be in seconds

Application.EnableEvents = True
Load UserForm1
UserForm1.Caption = "My File : MyStart - MyFinish"
UserForm1.WindowsMediaPlayer1.settings.autoStart = False

UserForm1.WindowsMediaPlayer1.URL = "C:\Myfile.mpg"
UserForm1.WindowsMediaPlayer1.Controls.currentPosi tion = MyStart 'Jumps
to start location
UserForm1.WindowsMediaPlayer1.Controls.Play
UserForm1.Show

Do you have any ideas for how to stop this? I could use Application.OnTime,
but this seems a little lame. Is there some way of monitoring
Controls.currentPosition?

"ZipCurs" wrote:

Hello Joel,

Thanks again for your support on this. Lamely, my ultimate solution might
just be putting the start and stop times in the UserForm caption, and let the
user deal with it.

"joel" wrote:


I've given up trying to use the Wijndows Media Player from VBA. I
didn't find much info on the web the last time I attempteed to program
the media player. I tried finding the DLL but there were a few
different DLL and the commands went well documented. People wanted to
get the music libraries into excel and I gave up.


VBA is really meant to be used by office products and other
functionality is there using the windos dll but it is not well
documented except for the web forums. You can get to a lot of features
using the VBA Reference libraries (menu tools - Reference). but you have
to know which function is in which library which isn't always easy to
find. Most of the experts learned using C lanaguage and adapted their C
Language expertese to VBA.

Microsoft compilers (Basic and C) have the libraries better documented
but the compilers still use the windos Dll just like VBA.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176787

Microsoft Office Help

.

You are now using the EMP.DLL and any references you find in any
language you can convert to basic language and use in your code. When
you added the ICON to your userform it automatically added the library
definition into excel. If yo go to the VBA menu tools - References you
will see the media play checked at the top of the refrences.


to get the library definitions open the Object Browser in VBa menu view
- Object Browser. Now type into the object browser search box (next to
the binoculars) WPM. The press the binoculars to do the search. You'll
find 1000 properties for the control. good Luck. I start to try to
work this control in the past and never found good documentation from
microsoft.

I may be able to help if you find any references that you don't
understand. Since you found some JAVA info I would continue to better
understand the JAVE which should lead you to the VBA solution.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176787

Microsoft Office Help