Launching animated video file from within Excel

[simon.q.rice]

Dear Excel experts,
I have created a training video for one of my workbooks that contains
flash automation. To launch the video you need the HTML file plus an
additional shockwave flash object file to be in the same folder
location.
I'd like for my users to be able to run this training video from
within Excel, via a command button. Unfortunately the users are
spread far and wide so we don't have any common drives or file shares
that we can use. Hence I thought of embedding the files as objects in
the workbook and launching from there. Here's where I came unstuck.
I have searched the archives and have found some code to launch a
single file from an embedded object, but how do I launch the two, or
group them together in one folder that's embedded? Is this possible?
Any other ideas how I might get this to work?

Thank you in anticipation

Simon

 

[simon.q.rice]

Dear Excel experts,
I have created a training video for one of my workbooks that contains
flash automation. To launch the video you need the HTML file plus an
additional shockwave flash object file to be in the same folder
location.
I'd like for my users to be able to run this training video from
within Excel, via a command button. Unfortunately the users are
spread far and wide so we don't have any common drives or file shares
that we can use. Hence I thought of embedding the files as objects in
the workbook and launching from there. Here's where I came unstuck.
I have searched the archives and have found some code to launch a
single file from an embedded object, but how do I launch the two, or
group them together in one folder that's embedded? Is this possible?
Any other ideas how I might get this to work?

Thank you in anticipation

Simon

I spent sometime researching this and now have a strategy to overcome
it but still need some assistance if anyone can help me please.
My thinking is to save these files to the directory the user's PC has
allocated for temporary internet files and then launch the files from
there. However where I come unstuck is saving the embedded files. I
can do it manually and the video launches correctly. I found some
code on the usergroup which saved the files but unfortunately the
video did not launch, when it was run.
Can anyone help me with some sample code to save embedded files
please?

Many thanks

Simon

 

[sfneil]

Simon,

I wish I could help you, but instead I am asking you for help?

Could you point me to where you found code to save the embedded files? I
need to programmatically save files embedded in Excel worksheets, but haven't
been able to figure out how to do it.

Thanks, and Good Luck!

Neil