Can Excel have a field to manage video in a playlist?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have a worksheet with data fields in a row with one field
being a link to a video clip that may be in a folder/playlist (WM player)?
 
Is it possible to have a worksheet with data fields in a row with one field
being a link to a video clip that may be in a folder/playlist (WM player)?
Click to expand...

Yes.

..wpl files use an XML format (open it with notepad), while inserting a
link to a video is as simple as inserting a link into the spreadsheet.
 
iliace said:
Yes.

..wpl files use an XML format (open it with notepad), while inserting a
link to a video is as simple as inserting a link into the spreadsheet.

Appreciate your suggestion, and while it helps, I'm probably not doing something right. When I open the .wpl file in Notepad, I see the .XML format. There is a list of 100+ video clips, which is correct. When I copy the individual clip address and paste it into a cell in an Excel worksheet, I get an error message advising that the address is not valid. I tried copying the address as a hyperlink but this also didn't work. Any ideas/suggestions? Is this documented anywhere? Thanks again.
Click to expand...
 
See if this makes it easier.

Import the .wpl file as text, in such a way that everything appears in
column A (no delimiter).

Use this formula in column B:

=IF(LEFT(TRIM(A1),
6)="<media",MID(A1,FIND(CHAR(34),A1)+1,FIND(CHAR(34),A1,FIND(CHAR(34),A1,1)+1)-
FIND(CHAR(34),A1)-1),"")

Use this formula in column C:

=IF(LEN(B1)>0,HYPERLINK(B1),"")

Copy down as needed.





Appreciate your suggestion, and while it helps, I'm probably not doing
something right. When I open the .wpl file in Notepad, I see the .XML
format. There is a list of 100+ video clips, which is correct. When
I copy the individual clip address and paste it into a cell in an
Excel worksheet, I get an error message advising that the address is
not valid. I tried copying the address as a hyperlink but this also
didn't work. Any ideas/suggestions? Is this documented anywhere?
Thanks again.- Hide quoted text -
 
Back
Top