How Can I List the Files in a Folder and All Its Subfolders?

re: How Can I List the Files in a Folder and All Its Subfolders?

palclan — Fri, 03 May 2013 11:10:33 GMT

And while I am shamelessly stealing code, please update with code below to avoid problems with directories using quote(s) in their name (stolen from David Brown on Google mailing list):

Rather than using the single-quote (') as a delimiter, you can use the double-quote

(") if you escape it. In VBS you escape a character by doubling it, so ""

. For some reason, this seems to work better in this situation.

Using the following revision, I was able to get folders with ' or } in them,

but I had to escape the backslashes ( \\ )

strFolderName = "c:\\quote_test\\b{o't}h"

"Associators of {Win32_Directory.Name=""" & strFolderName & """} " _

& "Where AssocClass = Win32_Subdirectory " _

& "ResultRole = PartComponent"

re: How Can I List the Files in a Folder and All Its Subfolders?

palclan — Fri, 03 May 2013 11:03:30 GMT

Am I the only one finding this part of code funny (and useless) ?

For Each objFolder in colSubfolders

GetSubFolders strFolderName

re: How Can I List the Files in a Folder and All Its Subfolders?

Ladders — Tue, 26 Feb 2013 18:11:31 GMT

This is great and almost what I'm looking for but ideally I want to create an XML file that has all of the file names in it rather than having them pop up on the screen... any idea on whether this is possible please and how to acheive it? Thanks

re: How Can I List the Files in a Folder and All Its Subfolders?

The Answer — Wed, 09 Jan 2013 09:34:09 GMT

If all the files are the same format, click on the base folder you want to list, and type the format into the search bar.

re: How Can I List the Files in a Folder and All Its Subfolders?

Chmmr — Mon, 09 May 2011 06:10:52 GMT

If you just need this as a listing you could use it via batch script.

1. Open Command Prompt (cmd)

2. go to the folder

(example C:\Files you would type

CD \

CD Files

3. Type (without quotation marks) "echo tree /F > listing.txt"

re: How Can I List the Files in a Folder and All Its Subfolders?

Stefan — Wed, 07 Jul 2010 10:43:32 GMT

I get a error with that script if I have a html file with a attached folder. This kind of folder which gets auto created if you save a Visio as Web page and the folder gets also deleted auto if you remove the html file. Was trying to fix that, but without success....

Error comes up with 0x80041017 on line 6 from the end.

re: How Can I List the Files in a Folder and All Its Subfolders?

Ed — Fri, 28 May 2010 14:40:14 GMT

This program crashes when it reaches a folder that looks like

C:\Program Files\Adobe\Reader 9.0\Setup Files\{AC76BA86-7AD7-1033-7B44-A93xxxxxxxxx}

Can anyone provide a solution please

re: How Can I List the Files in a Folder and All Its Subfolders?

Daz_1234 — Wed, 05 May 2010 12:57:42 GMT

"...and one which have avoided answering up till now."

Me thinks not ;o)

See FileSystemObject version here:

http://blogs.technet.com/heyscriptingguy/archive/2004/10/20/how-can-i-get-a-list-of-all-the-files-in-a-folder-and-its-subfolders.aspx

Regards,

Daz.