Re: Convert file names to a usable list?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


c:\documents and settings\gary\my documents\my music\artist\artist -
title.mp3

All i need in the list is "Artist" and "Title" from the file names,
bearing
in mind the mp3 files are in seperate "artist" directories.

I was hoping to use the "-" as the column/field seperator?

I don't know if this is possible?


Well, this is a bit like Jack Sprat and his wife.
You don't do script and I don't do Excel. :)
What you want is very easy, but I assume you
want a text file list that Excel can digest, and I
don't know anything about Excel.
If you can provide the exact syntax of a line
that's usable to Excel (something like artist, filename
maybe?) I can give you an edited script. It only
takes a minute.


.

Relevant Pages

  • Re: Using VBS Arrays As Data Ranges In Excel
    ... thanks for the tip on Excel ... Let me give the updated script a try and see how it works out tomorrow... ... Should I be creating the Excel object ... Dim objExcelApp ' Excel application object ...
    (microsoft.public.scripting.vbscript)
  • Re: Excel macro (long)
    ... You should ask this in an Excel programming forum. ... > I found a vbs script that pulls in the time a user logs in to the network ... > Dim objRootDSE, strConfig, objConnection, objCommand, strQuery ... > On Error GoTo 0 ...
    (microsoft.public.word.vba.beginners)
  • RE: Export options
    ... I'm trying to implement your code in my VB app, and I think it will work - ... - but my VB6 is more than a little rusty, ... to do it from this script anyway. ... manipulates each Excel file using that object's methods etc. ...
    (microsoft.public.excel.programming)
  • RE: Export options
    ... (please remember to click yes if replies you receive are helpful to you) ... to do it from this script anyway. ... manipulates each Excel file using that object's methods etc. ... It is written so that it will only amend and save files where gridlines are ...
    (microsoft.public.excel.programming)
  • RE: Export options
    ... to do it from this script anyway. ... manipulates each Excel file using that object's methods etc. ... The one left in saves the files with an amended filename ... It is written so that it will only amend and save files where gridlines are ...
    (microsoft.public.excel.programming)