Results 1 to 19 of 19

MP3 File Info Details

Threaded View

  1. #1
    Registered User
    Join Date
    09-29-2014
    Location
    New Zealand
    MS-Off Ver
    Office 365
    Posts
    16

    MP3 File Info Details

    I need some help with trying to extract details from MP3 files that I use for work purposes.

    I have a library of over 900 MP3 tracks and I found the attached excel file that runs a macro which reads a music folder and extracts details of the MP3 tracks. There is one parameter that I need to extract but I'm unsure what string I need to use. I need to extract the composer details. The file has the following code that extracts the other details I require.


               If UCase(Right(filename, 3)) = "MP3" Then
                    Row = WorksheetFunction.CountA(Range("A:A")) + 1
                    Cells(Row, 1) = currdir 'path
                    Cells(Row, 2) = filename 'filename
                    Cells(Row, 3) = FileInfo(currdir, filename, 20) 'artist
                    Cells(Row, 4) = FileInfo(currdir, filename, 14) 'album
                    Cells(Row, 5) = FileInfo(currdir, filename, 21) 'title
                    Cells(Row, 6) = FileInfo(currdir, filename, 26) 'track
                    Cells(Row, 7) = FileInfo(currdir, filename, 16) 'genre
                    Cells(Row, 8) = FileInfo(currdir, filename, 27) 'duration
                    Cells(Row, 9) = Application.Round(FileLen(currdir & filename) / 1024, 0) 'size
                    Application.StatusBar = Row
    I've tried every number between 1 and 100 after 'filename' but none extract the composer details. I know the composer details exist in the metadata of the file as it lists the composers when I view the MP3 file properties in windows explorer. I tried to attach a short MP3 to this post, but got invalid file.

    If anybody can assist me with this then that would be much appreciated.

    The original author of the xls file requests on their webpage for no contact for help with their files, but states he is happy for people to freely use the file.

    Cheers
    Harry
    Attached Files Attached Files
    Last edited by JBeaucaire; 10-02-2014 at 12:19 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 02-10-2014, 11:52 AM
  2. Create folder, excel file, pdf file, clear details macro
    By cemartinho in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2013, 08:52 AM
  3. Replies: 0
    Last Post: 08-21-2012, 01:19 AM
  4. How to add Time & Date details in file name using VBA
    By Alan Stuart in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2010, 11:42 AM
  5. List file details into a worksheet, is it possible?
    By JoshS in forum Excel General
    Replies: 1
    Last Post: 12-15-2008, 11:51 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1