Can a macro pull details from a folder into the excel document

[KingLouhichi]

Hi Everyone, this is my very first post. I am try to automate my school work a little quicker. I want to pull the first and second string from a folder name, usually the first and last names of people, and then put this into an excel worksheet with column A being the first name and column B being the second name. Is this possible with VBA, any help will be appreciated.

Thanks