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