Import filename into seperate columns?

[dark91zc]

i have a macro that is called get folder contents and i am wondering if there is a way to break up the file name structure to place different parts into different column?
example
doe, john 12-31-1978 06-09-78
smith, bob 06-15-1922 12-85-99

name d.o.b. mdr

or

doe, john 06-09-78 2008
smith, bob 12-85-99 2011

name mdr year

what i would like is to have it where name is in one column, dob in another, then mdr in the last one. if i was going to use it on different file name formats will i have to change the code to work with the new file name?



i am new to programming excel. and thanks for the help. i can post that macro i have if need be.