Yes, but I might use DOS anyway. Use DIRs /b (bare) switch.

Try DIR *.txt list.txt /b or DIR *.txt list.txt /b/s if you want to list
the full path and/or search subdirectories.

--
Bob Kilmer

"robert" wrote in message
...
Hello,

I'm trying to find a way to create a file list.
Right now I go to "dos" and do a dir *.txt list.txt
and then strip out by hand what I dont' need bytes dates etc.

Is there a way to do this in excel using vb

thanks
rob