Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. -- Regards, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data value display attributes linked to table attributes | Charts and Charting in Excel | |||
Getting NTFS file attributes | Excel Discussion (Misc queries) | |||
File Attributes | Excel Programming | |||
Filecopy, file attributes | Excel Programming | |||
File Attributes | Excel Discussion (Misc queries) |