LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 175
Default More File Attributes needed

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data value display attributes linked to table attributes MDT at Paragon Home Inspections, LLC Charts and Charting in Excel 0 November 15th 06 12:53 AM
Getting NTFS file attributes Kiran Excel Discussion (Misc queries) 1 August 4th 05 08:13 PM
File Attributes [email protected] Excel Programming 5 March 29th 05 05:06 PM
Filecopy, file attributes Eric[_28_] Excel Programming 1 February 24th 05 01:31 PM
File Attributes dsti3 Excel Discussion (Misc queries) 1 February 10th 05 05:51 AM


All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"