Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Exporting audio file names and lengths to excel

  1. #11
    Board Regular
    Join Date
    Oct 2009
    Location
    New Mexico, USA
    Posts
    455

    Default Re: Exporting audio file names and lengths to excel

    I really like the "mciSendString " option. I used to have to figure out the audio length by using a formula that used the file size. This is much cleaner.

  2. #12
    Board Regular
    Join Date
    Oct 2009
    Location
    New Mexico, USA
    Posts
    455

    Default Re: Exporting audio file names and lengths to excel

    One other method would be to use the FileSystemObject...
    Code:
        
    Dim fs As Object     
    Dim objFolder As Object     
    Dim objFile As Object          
    Dim Folder as String
    
    Folder = "C:\AudioFiles\"  'Not sure if you need the last backslash
    
    Set fs = CreateObject("Scripting.FileSystemObject")     
    Set objFolder = fs.GetFolder(FolderName)          
    For Each objFile In objFolder.Files

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com