+ Reply to Thread
Results 1 to 2 of 2

Creating Excel List from data in Windows folder -- with LENGTH

  1. #1
    Registered User
    Join Date
    04-27-2017
    Location
    Denver, CO
    MS-Off Ver
    2013
    Posts
    1

    Creating Excel List from data in Windows folder -- with LENGTH

    Hello - I hope this is the proper sub-forum for this question.

    We found an online article giving instructions for copying a list of files in a windows folder into excel, using a command window prompt.

    It worked great for the file names. However, these are audio files and I need the length as well as the name for my Excel spreadsheet.

    I can't find any way to include the length - only name, file size and file date.

    Does anyone know of a way to export Length?

    thanks, Becky M.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Creating Excel List from data in Windows folder -- with LENGTH

    Hi Piper,

    I don't think there is a way using normal Excel or VBA. There is one link that claims using a DirectX dll he could get length info at:

    http://stackoverflow.com/questions/8...-wav-file-in-c
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Specific folder when opening windows popup folder selection with msoFileDialogFolderPicker
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2015, 11:05 AM
  2. [SOLVED] Where is default excel folder on Windows 8 and 7?
    By zanshin777 in forum Excel General
    Replies: 4
    Last Post: 06-07-2015, 01:25 PM
  3. Create list of files from windows explorer folder
    By Economakos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2014, 04:10 PM
  4. Link excel cell to folder in Windows directory
    By jamesrm in forum Excel General
    Replies: 1
    Last Post: 09-18-2012, 11:42 AM
  5. Creating CULUM results - Folder / Sub Folder from excel macro
    By mash1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2012, 10:19 AM
  6. Replies: 0
    Last Post: 07-13-2012, 10:51 PM
  7. import list of files from folder in windows XP
    By Ian Murdoch in forum Excel General
    Replies: 4
    Last Post: 04-14-2010, 10:40 AM

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