Spreadsheet Showing All Things In A Folder?

[Ste_Moore01]

Hi all,

I'm trying to make a Spreadsheet that shows all the files in a folder and automatically updates them when a new file is added.

Is there any way of doing this without having to do it manually?

 

[wwbwb]

This code will look for a directory path in a1 and return the file name and path in a5 down. b5 down will display the extension (.xls, .jpg, etc.) If you put an "x" in b1, it will list the files as links so you can click on it.

 

[Ste_Moore01]

Which part of your code would I change to enter the address of my folder?

Also, the asap utilites has a similar function to what I'm after but I can't get the code for it as it password protected and I'm hoping to add it to my menu that I've been creating.

 

[wwbwb]

fPath = Range("A1")

 

[Ste_Moore01]

Sorry you must've been posting at the same time as me.

Thanks for that, wwbwb, it works perfectly.