Is there a way to extract a list into excel, a list of all the filenames in a folder, into a spreadsheet? I would like them to be in column E, leaving the first row blank, using a userform to search for the folder I would like to focus on. Copy them in as text.
This step I will do, a couple other extracts, into column A, B and C, concatenating them to create a new filename... using a better naming convention.
Then replace the existing filename from our first step column E, with a new one that will be in column D which will be a result of the concatenation.
Has anyone ever done this? Please advise and thanks. -R-