Obtain folder names in a excel sheet

[furbiuzzu]

Hi all,

i've to write a VB excel macro able to create a list (inside an excel
sheet) of specific folders contained in a bigger one.

i.e.

the "source folder" contains other ones named:

Data1
Data2
xml 05.05.06
xml 04.05.06
xml 03.05.06
.......
........

i would like to obtain just :

05.05.06
04.05.06
03.05.06

in some excel sheet cells

thanks in advance

 

[Brian Taylor]

Check out this thread that shows examples of using the file system
object:

http://groups.google.com/group/micr...=vba+list+all+folders&rnum=3#091fa4e9b1c25dcc

You could pretty easily put a line in that says to look for "xml" at
the beginning of the folder name.