I have developed quite a complex Exel workbook application.
I have used a simply ScreenCapture program, to record(.avi) how to use the various components of the
Workbook.

What would be the BEST way to have these Video's (.avi) files associated to the Workbook and run if
needed?

Can Excel run the .Avi from a Forms Button ?
How do i go about this if it can?

Regards

Corey....

Not sure EXACTLY what you mean, or what version you have, but if you go to
your userform right-click the toolbox and additional controls there is a
windows media player control that is very easy/intuitive to use if you have
it.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Corey" wrote:

I have developed quite a complex Exel workbook application.
I have used a simply ScreenCapture program, to record(.avi) how to use the various components of the
Workbook.

What would be the BEST way to have these Video's (.avi) files associated to the Workbook and run if
needed?

Can Excel run the .Avi from a Forms Button ?
How do i go about this if it can?

Regards

Corey....

Thnaks John.
I am using Excel XP.
I added the WMP option but how do i set it to play a .Avi when the userform initializes ?

"John Bundy" (remove) wrote in message
...
Not sure EXACTLY what you mean, or what version you have, but if you go to
your userform right-click the toolbox and additional controls there is a
windows media player control that is very easy/intuitive to use if you have
it.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Corey" wrote:

I have developed quite a complex Exel workbook application.
I have used a simply ScreenCapture program, to record(.avi) how to use the various components of
the
Workbook.

What would be the BEST way to have these Video's (.avi) files associated to the Workbook and run
if
needed?

Can Excel run the .Avi from a Forms Button ?
How do i go about this if it can?

Regards

Corey....

Load your form with whatever method you choose, then on the activate place
the addy like this, this is just a sample from a system avi on my comp

Private Sub UserForm_Activate()
WindowsMediaPlayer1.URL = "C:\Documents and Settings\BIS Student\My
Documents\My Universal Skins\mySkins\161.avi"

End Sub
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Corey" wrote:

Thnaks John.
I am using Excel XP.
I added the WMP option but how do i set it to play a .Avi when the userform initializes ?

"John Bundy" (remove) wrote in message
...
Not sure EXACTLY what you mean, or what version you have, but if you go to
your userform right-click the toolbox and additional controls there is a
windows media player control that is very easy/intuitive to use if you have
it.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Corey" wrote:

I have developed quite a complex Exel workbook application.
I have used a simply ScreenCapture program, to record(.avi) how to use the various components of
the
Workbook.

What would be the BEST way to have these Video's (.avi) files associated to the Workbook and run
if
needed?

Can Excel run the .Avi from a Forms Button ?
How do i go about this if it can?

Regards

Corey....

Thank you John.
Go the .Avi to play in a Screen Sized U/F.
Is there anyway to Have the Userform "Unload me" when the Avi finishes ?


"John Bundy" (remove) wrote in message
...
Load your form with whatever method you choose, then on the activate place
the addy like this, this is just a sample from a system avi on my comp

Private Sub UserForm_Activate()
WindowsMediaPlayer1.URL = "C:\Documents and Settings\BIS Student\My
Documents\My Universal Skins\mySkins\161.avi"

End Sub
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Corey" wrote:

Thnaks John.
I am using Excel XP.
I added the WMP option but how do i set it to play a .Avi when the userform initializes ?

"John Bundy" (remove) wrote in message
...
Not sure EXACTLY what you mean, or what version you have, but if you go to
your userform right-click the toolbox and additional controls there is a
windows media player control that is very easy/intuitive to use if you have
it.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Corey" wrote:

I have developed quite a complex Exel workbook application.
I have used a simply ScreenCapture program, to record(.avi) how to use the various components of
the
Workbook.

What would be the BEST way to have these Video's (.avi) files associated to the Workbook and run
if
needed?

Can Excel run the .Avi from a Forms Button ?
How do i go about this if it can?

Regards

Corey....

Corey,
This seems to work:

Private Sub MediaPlayer1_EndOfStream(ByVal Result As Long)
Unload Me
End Sub

NickHK

"Corey" wrote in message
...
Thank you John.
Go the .Avi to play in a Screen Sized U/F.
Is there anyway to Have the Userform "Unload me" when the Avi finishes ?


"John Bundy" (remove) wrote in message
...
Load your form with whatever method you choose, then on the activate place
the addy like this, this is just a sample from a system avi on my comp

Private Sub UserForm_Activate()
WindowsMediaPlayer1.URL = "C:\Documents and Settings\BIS Student\My
Documents\My Universal Skins\mySkins\161.avi"

End Sub
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Corey" wrote:

Thnaks John.
I am using Excel XP.
I added the WMP option but how do i set it to play a .Avi when the
userform initializes ?

"John Bundy" (remove) wrote in message
...
Not sure EXACTLY what you mean, or what version you have, but if you go
to
your userform right-click the toolbox and additional controls there is a
windows media player control that is very easy/intuitive to use if you
have
it.
--
-John Northwest11
Please rate when your question is answered to help us and others know
what
is helpful.


"Corey" wrote:

I have developed quite a complex Exel workbook application.
I have used a simply ScreenCapture program, to record(.avi) how to use
the various components of
the
Workbook.

What would be the BEST way to have these Video's (.avi) files
associated to the Workbook and run
if
needed?

Can Excel run the .Avi from a Forms Button ?
How do i go about this if it can?

Regards

Corey....

Corey,

If Nick's suggestion works for you, it seems better to me, but in case it
doesn't this does seem to work in XL 2003 win XP:

Private Sub WindowsMediaPlayer1_PlayStateChange(ByVal NewState As Long)
If NewState = 1 Then '1 = "stopped"
Unload Me
End If
End Sub

hth,

Doug

"Corey" wrote in message
...
Thank you John.
Go the .Avi to play in a Screen Sized U/F.
Is there anyway to Have the Userform "Unload me" when the Avi finishes ?


"John Bundy" (remove) wrote in message
...
Load your form with whatever method you choose, then on the activate place
the addy like this, this is just a sample from a system avi on my comp

Private Sub UserForm_Activate()
WindowsMediaPlayer1.URL = "C:\Documents and Settings\BIS Student\My
Documents\My Universal Skins\mySkins\161.avi"

End Sub
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Corey" wrote:

Thnaks John.
I am using Excel XP.
I added the WMP option but how do i set it to play a .Avi when the
userform initializes ?

"John Bundy" (remove) wrote in message
...
Not sure EXACTLY what you mean, or what version you have, but if you go
to
your userform right-click the toolbox and additional controls there is a
windows media player control that is very easy/intuitive to use if you
have
it.
--
-John Northwest11
Please rate when your question is answered to help us and others know
what
is helpful.


"Corey" wrote:

I have developed quite a complex Exel workbook application.
I have used a simply ScreenCapture program, to record(.avi) how to use
the various components of
the
Workbook.

What would be the BEST way to have these Video's (.avi) files
associated to the Workbook and run
if
needed?

Can Excel run the .Avi from a Forms Button ?
How do i go about this if it can?

Regards

Corey....