Parsing multiple songs (Playlist) through to Windows Media player

%3CLINGO-SUB%20id%3D%22lingo-sub-2542368%22%20slang%3D%22en-US%22%3EParsing%20multiple%20songs%20(Playlist)%20through%20to%20Windows%20Media%20player%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2542368%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20Excel%202010%20on%20Windows%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20parsing%20the%20full%20path%20and%20filename%20of%20an%20.MP3%20through%20to%20Windows%20as%20per%20below%2C%20and%20it%20works%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EActiveSheet.OLEObjects.Add(Filename%3A%3DFullPathSongTitle%2C%20Link%3A%3DTrue).Select%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%2C%20however%2C%20like%20to%20parse%20a%20play%20list%20through%2C%20and%20have%20done%20so%20using%20an%20array%2C%20but%20only%20the%20last%20song%20will%20play%20due%20to%20there%20not%20being%20a%20following%20song%20to%20overwrite%20it.%20(being%20the%20last%20song%20in%20the%20array%20obviously)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20self%20taught%20novice%2C%20and%20would%20greatly%20appreciate%20any%20assistance%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2542368%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EParsing%20songs%20through%20to%20Media%20Player%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi

 

I'm using Excel 2010 on Windows 365.

 

I'm parsing the full path and filename of an .MP3 through to Windows as per below, and it works fine.

 

ActiveSheet.OLEObjects.Add(Filename:=FullPathSongTitle, Link:=True).Select

 

I would, however, like to parse a play list through, and have done so using an array, but only the last song will play due to there not being a following song to overwrite it. (being the last song in the array obviously)

 

I am a self taught novice, and would greatly appreciate any assistance

Cheers

 

 

0 Replies