Quote Originally Posted by anilsolipuram
Are all the workbooks in same directory.

so you want to copy all the workbook into single workbook.

It is not clear, can you explain in detail.


I have a random number of text files (between 3-7). All of these text files are in the same directory.

I want to open the first text file in Excel and, after formatting it, copy its contents into a pre-existing Excel file (which is already open & located in a different directory).

I then wish to close the text file without saving it, open the second text file in Excel, copy its contents into the pre-existing Excel file, and so forth.

The names of the text files change daily.

I hope this clarifies things.