List of Files in Directory

[gripper]

Good Evening,

I have a directory on my c:\ drive that has about 10 sub directories. Within these sub directories are a bunch of .csv files.

I would love to have these list the file name in an excel workbook book - sheet 1.

Basically it would just list there full file name down column A. I do not need anything else just the file name.

As always I appreciate all the assistance from this forum

Thanks

 

[gripper]

Please disregard this post.

I search the forum before I posted and did not find a code that worked. I searched after using a different syntax and found a perfect code.

Thanks