View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Listing the contents of a folder

It would help if you mapped the folder that you want to list out to a drive.

I do this as follows:

Start - Run - cmd

I have multiple drives mapped. Let's say I want to get a listing of the Y
drive.

I type in Y:

I then type:

dir/s z:textfile.txt

It will save a listing of the Y drive on my Z drive as a file named
textfile.txt

Good luck.


" wrote:

I am looking to write a macro that will list the contents of a
specified folder, including the contents of subfolders. Is this
something that i can do with a macro?

Thanks.

Asa