Extract file names from folder`

**Dri** · 05-29-2007, 07:46 AM

I've recently been given a couple of hard-drives with a large and umanageable number of video files in a couple of folders. I want to create an excel sheet with a list of file names extracted from each folder. Ideally these will be hyperlinked back to the original files.
The hyperlinking I'm assuming needs to be done manually, but can I automate the entry for the list of files?

**mudraker** · 05-29-2007, 08:14 AM

Have a look at

http://www.vbaexpress.com/kb/getarti...da54213fdf7d82

**NBVC** · 05-29-2007, 08:36 AM

After you've run the code suggested by mudraker, you can concatenate the results to create a hyperlink.

Assuming the directory info extracted takes up columns A:H, then put this formula in I1 and copy down.

=HYPERLINK(LEFT(CONCATENATE(A1,"\",B1,"\",C1,"\",D1,"\",E1,"\",F1,"\",G1,"\",H1,"\"),FIND(".xls",CONCATENATE(A1,"\",B1,"\",C1,"\",D1,"\",E1,"\",F1,"\",G1,"\",H1,"\"))+3))

then you can hide columns A:H so that I is the only visible column.

You may need to adjust the formula by adding/subtracting cell refs depending on the length of your paths.