Hi,
I have different text files that I need to open in excel, run the same macro on and then save the file as an excel file using the same file name. I have the names of the files currently listed in a workbook as 3 columns - the path, the file name and then the extension. I've set it up this...