Files and files sizes in directory

**paularthur90** · 07-30-2015, 03:59 PM

Hi,

I have been searching the internet high and low and still cannot fine anything directly related to what I need.

I need a macro to output a list of files that are contained in a directory. I also need to output next to that list either the size of the file in KB or the length of the WAV files that are in it. I ask for either one or the two as I can roughly estimate that 2kb in 1 second of recording.

Could someone please help me?

Thanks,
Paul

**xladept** · 07-30-2015, 04:14 PM

Here's some code I had on hand - see if it suits your purpose (it may need some tweaking):

Please Login or Register  to view this content.

**mc84excel** · 07-30-2015, 07:23 PM

I think I have a VBS for this somewhere. If I find it, I'll upload it.

Another option - but more involved - see my thread here for a project for returning lists of files/folders http://www.excelforum.com/excel-prog...stage-3-a.html You could cannabilise code from this and use FileLen on each file

Files and files sizes in directory

LinkBack

Thread Tools

Rate This Thread

Display

Files and files sizes in directory

Re: Files and files sizes in directory

Re: Files and files sizes in directory

Thread Information

Users Browsing this Thread

Similar Threads

Loop all excel files in a directory and convert each worksheet of the excel files to text

Moving Files from one directory structure to another directory

[SOLVED] Macro to Import Multiple TXT Files into workbook - User to select files/directory

Loop through all .xlsx files in directory and copy data in those files into a new file

Macro to Move files from one directory to other directory

Reading in the files in a directory into an array, directory chosen by user

Delete all files in directory, msgbox list files before delete.

Reducing files sizes... are macros the solution

Bookmarks

Bookmarks

Posting Permissions