List All Files In Folder

**Rikuk** · 05-07-2009, 03:01 PM

Evening,
I have a folder C:\My Documents that contains excel & Pdf files.
Is it possible to list all the files by name contained in this folder in a excel spreadsheet i.e one filename one cell?

RIk

**Palabalo** · 05-07-2009, 03:34 PM

As far as an automatic updating spread sheet, I dont know how to do that but, I can get a txt file so you can import to excel

Start--Run
CMD--enter

you should get dos

navigate to the location you want using cd commands
http://www.computerhope.com/cdhlp.htm

Then type "dir /b>filelist.txt"

This will create a txt file named "filelist" in the folder you navigated too.

You then can import and edit to your delight!

Hope this helped!

found a wiki with more info also!
http://wiki.bugwood.org/BugwoodIDS:I...mes_into_Excel

**broro183** · 05-07-2009, 03:55 PM

hi Rik,

Below is another aproach (run the "ListFilesAndFolders" macro) which will put the info in a new sheet (I think it is completely functional in Excl 2003 & above). I've left the notes about where I found the original code & here's a google which brings up lots of answers:

http://www.google.co.uk/search?q=%22...xcel+sub&meta=
including Richard Schollar's suggestion in:
http://www.ozgrid.com/forum/showthread.php?t=65530
or
http://www.dbforums.com/microsoft-ex...es-folder.html

Please Login or Register  to view this content.

hth
Rob

**royUK** · 05-07-2009, 03:57 PM

Maybe this

Please Login or Register  to view this content.

**Rikuk** · 05-07-2009, 05:02 PM

Thank you all for your help

Rik

List All Files In Folder

LinkBack

Thread Tools

Rate This Thread

Display

List All Files In Folder

Re: List All Files In Folder

Re: List All Files In Folder

Re: List All Files In Folder

Re: List All Files In Folder

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions