Hey Everybody!
Noob here. Very new to VB and using it with Excel. Like 2 days. I've been able to pick up tonnes of info from this site and Google, but can't make it any further on my own.
I've created a worksheet containing all the MMA fights I have ripped to my PC (~500). I have columns for Winner, Loser and Hyperlink. I have setup a filter that will show only the fights with a certain fight, win or lose. I'd like to take that filtered information and copy it into .m3u playlist file to load into a media player.
What I've been able to figure out so far is:
How do I setup the loop to continue writing the information to the playlist until it hit the end of the filtered results? Also, how do I extract the friendly name and link location from the hyperlinks?
Don't know if it makes a difference or not, but I did not used CRTL+K to create the hyperlinks, not the =hyperlink function.
Thanks in advance for your help!
Noob here. Very new to VB and using it with Excel. Like 2 days. I've been able to pick up tonnes of info from this site and Google, but can't make it any further on my own.
I've created a worksheet containing all the MMA fights I have ripped to my PC (~500). I have columns for Winner, Loser and Hyperlink. I have setup a filter that will show only the fights with a certain fight, win or lose. I'd like to take that filtered information and copy it into .m3u playlist file to load into a media player.
What I've been able to figure out so far is:
Code:
Sub WriteToATextFile()
Set WshShell = CreateObject("WScript.Shell")
ChDir (WshShell.SpecialFolders("desktop"))
MyFile = "" & "playlist.m3u"
fnum = FreeFile()
Open MyFile For Output As fnum
Print #fnum, "#EXTM3U"
Print #fnum,
Print #fnum, "#EXTINF:,(FRIENDLY_NAME of 1st Result)"
Print #fnum, "(LINK_LOCATION)"
Print #fnum,
Print #fnum, "#EXTINF:,(FRIENDLY_NAME of 2nd Result)"
Print #fnum, "(LINK_LOCATION)"
Print #fnum,
'at this point it would loop until it hit the end of the filtered results
Close #fnum
End Sub
How do I setup the loop to continue writing the information to the playlist until it hit the end of the filtered results? Also, how do I extract the friendly name and link location from the hyperlinks?

Don't know if it makes a difference or not, but I did not used CRTL+K to create the hyperlinks, not the =hyperlink function.
Thanks in advance for your help!