J
John Keith
This may not be the best place to post this, but I am at least somewhat
familiar with VBA in excel, and not at all famiiar with any scripting (but I
want to learn).
I have found the FileDateTime function that will return a time stamp which
is the date modified for a file. This returns the complete time stamp
including down to the HH:MM:SS. I really need this level of data for the
"date created" attribute however. Then using a sort by the created date, I
want to generate a "track number"
This is for generating a list of files, and a rename of the file with either
this new "track number" as the first part of each file name. Better yet, I
would want to update the file attribute named "Track Number" (which is one of
the possible file details, [columns] that is seen when looking at a folder:
name, size, file type, author, Date Modified, Date Created, Atributes,
owner, title, Artist, Album Title, year, Track number, BitRate, Channels,
etc(20-30 more on the "choose details" selection list when right clicking the
columns shown in a folder) <-- wordy i know, but I wanted to make sure to
communicate exactly what i am trying to change. Track number as a column is
on each of my song files, but the data is missing. Apparently when
RealPlayer was recording these, it only updated ITS own database with the
track number but not the file details. And now Real Players database is
corrupted so title names randomly point to the wrong files.
I have mistakenly messed up the file names for songs recorded from Music
CD's so that the filename was stored in Artist/Album/artist - album -
song.wav format. I figure I could use a macro/script or some combination of
tools to rename the files so that the Artist/album is maintained in the
subdirectory structure, and the name is track-song... or just song, with the
"track number" file atribute or detail (unsure of the correct term) set to
the proper track order.
**WSH code I found ...
Set objShell = CreateObject("Shell.Application")
Set Ag=Wscript.Arguments
Set Fldr=objShell.NameSpace(Ag(0))
The code does return the text of all the file attributes but the Date
Created does not show the seconds, its stops at HH:MM which is not good
enough for assigning a track number.
I am just trying to take this one step at a time, I need to get a listing of
all my music files with the proper track number to start with. (can tackle
getting them renamed and attributes re-set later)
I'm open to any other possible solutions. All ideas are welcome.
familiar with VBA in excel, and not at all famiiar with any scripting (but I
want to learn).
I have found the FileDateTime function that will return a time stamp which
is the date modified for a file. This returns the complete time stamp
including down to the HH:MM:SS. I really need this level of data for the
"date created" attribute however. Then using a sort by the created date, I
want to generate a "track number"
This is for generating a list of files, and a rename of the file with either
this new "track number" as the first part of each file name. Better yet, I
would want to update the file attribute named "Track Number" (which is one of
the possible file details, [columns] that is seen when looking at a folder:
name, size, file type, author, Date Modified, Date Created, Atributes,
owner, title, Artist, Album Title, year, Track number, BitRate, Channels,
etc(20-30 more on the "choose details" selection list when right clicking the
columns shown in a folder) <-- wordy i know, but I wanted to make sure to
communicate exactly what i am trying to change. Track number as a column is
on each of my song files, but the data is missing. Apparently when
RealPlayer was recording these, it only updated ITS own database with the
track number but not the file details. And now Real Players database is
corrupted so title names randomly point to the wrong files.
I have mistakenly messed up the file names for songs recorded from Music
CD's so that the filename was stored in Artist/Album/artist - album -
song.wav format. I figure I could use a macro/script or some combination of
tools to rename the files so that the Artist/album is maintained in the
subdirectory structure, and the name is track-song... or just song, with the
"track number" file atribute or detail (unsure of the correct term) set to
the proper track order.
**WSH code I found ...
Set objShell = CreateObject("Shell.Application")
Set Ag=Wscript.Arguments
Set Fldr=objShell.NameSpace(Ag(0))
The code does return the text of all the file attributes but the Date
Created does not show the seconds, its stops at HH:MM which is not good
enough for assigning a track number.
I am just trying to take this one step at a time, I need to get a listing of
all my music files with the proper track number to start with. (can tackle
getting them renamed and attributes re-set later)
I'm open to any other possible solutions. All ideas are welcome.