video clip in Excel
I have embedded a video clip in a spreadsheet and I have written a macro that
runs the video. It looks like this:
Sheets("Movie").Select
Range("F10").Select
ActiveSheet.Shapes("Object 1").Select
Selection.Verb Verb:=xlPrimary
It works great, UNLESS I copy the spreadsheet to another drive, Then the
macro can't find the AVI file and it opens an explorer type window to locate
the file.
Is there a way to have the macro look in the directory that the spreadsheet
is in for the AVI file? I can use the ActiveWorkbook.Path command to find
the current directory. Can I apply that to the AVI object?
Thanks
|