Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel with Video Usage | Excel Discussion (Misc queries) | |||
Import a video into Excel | Excel Discussion (Misc queries) | |||
Excel and video | Excel Discussion (Misc queries) | |||
video in excel | Excel Discussion (Misc queries) | |||
Excel and Video? | Excel Programming |