I want to create a macro that opens up a text file from a folder, formats the data, and then outputs it to excel in to a row. I then want it to automatically do the same for the next text file in the folder and enter the formatted data into the next row in excel. I want it to continue to do this for all text files in the folder. I already created a macro to do the opening of the text file and formatting into a row in excel, but I don’t know how to increment this command to the next text file and to insert the formatted data to the next row. This is probably really easy but I don’t know how. Can anyone help?