Assuming the text files are always the same name and always in the same
place, you won't have to write any code. Just go to Tools...Macro...Record
New Macro, then go through your process, then stop recording.

"acechef11" wrote:

I receive hundreds of text files daily that i have to convert to excel. How
can I automate the process so that i dont have to manually open every text
file one at a time?