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

Exporting audio file names and lengths to excel

This is a discussion on Exporting audio file names and lengths to excel within the Excel Questions forums, part of the Question Forums category; I really like the "mciSendString " option. I used to have to figure out the audio length by using a ...

  1. #11
    MPW
    MPW is offline
    Board Regular
    Join Date
    Oct 2009
    Location
    New Mexico, USA
    Posts
    340

    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
    MPW
    MPW is offline
    Board Regular
    Join Date
    Oct 2009
    Location
    New Mexico, USA
    Posts
    340

    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

Page 2 of 2 FirstFirst 12

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