Help needed referencing an embedded file
 

Hello - might I ask help of the experts here please?

I have a macro in a spreadsheet that references back to a video file (Mfile
= "test.avi")
I want to e-mail the spreadsheet to a friend but in order to do so, she will
have to separately copy the file test.avi to her c drive to make the macro
function. This is inconvenient.
Obviously I can embed the file test.avi into the spreadsheet as an object,
but how can I change the VB code to directly reference it. I'm no VB expert,
so any help would be appreciated

Best

TP