vba macro to create .txt list of filepaths
<p>I have a macro to list out all the files in subfolders of a particular folder. what I want to do is create a .txt file in the main folder that has a list of all the filepaths? Basically a macro to create a txt file which lists column A of my excel spreadsheet. I know this is easy to do without vba(you just save as a text file) but i need to find a way to automate it?!</p>