<job> <object id = oRS progid = "ADODB.Recordset"/> <reference object = "ADODB.Recordset"/> <script language = "VBScript"> Option Explicit Sub DefineAndOpenRS() 'Define and open the disconnected recordset With oRS .ActiveConnection = Nothing .CursorLocation = adUseClient .CursorType = adOpenStatic .LockType = adLockBatchOptimistic With .Fields .Append "MyStuff", adVarChar, 255 End With .Open End With End Sub Sub InsertRow(sData) 'Add data to a new row in the recordset oRs.AddNew oRS.Fields.Item("MyStuff").Value = sData End Sub Function ConcatRows() With oRS .MoveFirst ConcatRows = "" Do if oRS.Fields.Item("MyStuff").Value = "playlist generator" or _ oRS.Fields.Item("MyStuff").Value = "playlist.m3u" then ' do nothing else ConcatRows = ConcatRows _ & .Fields.Item("MyStuff").Value _ & vbNewLine end if .MoveNext Loop Until .EOF End With End Function Dim lItem, sResults DefineAndOpenRS dim fso Set fso = CreateObject("Scripting.FileSystemObject") dim folder Set folder = fso.GetFolder(".") dim fileList Set fileList = folder.Files dim playListFile Set playListFile = folder.CreateTextFile("playlist.m3u", true) dim file for each file in fileList if file.Name = "playlist generator.wsf" or file.Name = "playlist.m3u" then ' do nothing else InsertRow(file.Name) end if next oRS.Sort = "MyStuff ASC" do while not oRS.eof playListFile.WriteLine(oRS.Fields.Item("MyStuff").Value) oRS.movenext loop playListFile.Close sResults = ConcatRows() oRS.Close MsgBox sResults, vbOkOnly </script> </job>
Monday, January 28, 2008
An initial public offering
I no longer know how this thing works and so I must set it free. My old roomate remembers me cracking away at this some years ago - I'll take his word for it. I should probably remove VBScript from my résumé (and good riddance!).
Save this text into a text file with a .wsf extension (i.e. playlistgenerator.wsf)
It is a playlist generator BTW.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment