Importing Most Recent .txt File from Folder

[cleatkete]

I am doing some research that involves importing data sets collected by an external instrument that can only be stored as .txt files. They are always stored in the same folder and importing them with the correct formatting is extremely repetitive and can be tedious. Is there a way for Excel 2016 to find the file name in the folder and import it? One data source is delimited and the other is not so I would love to know how to do it both ways!

 

[GWteB]

What you are asking for is basically determining the name of a file located in a specific folder, based on the most recent date & time stamp of all files in that folder. Am I right?

 

[GWteB]

... if that's a part of your request, then you may be able to do something with the code I posted over here ...

Pulling Downloaded File

I am looking to do a complicated task with a macro. For work, one of my responsibilities is updating data on a program that runs online. When I export the data into excel, it creates a new file with a new filename in the Downloads Folder. Is there a way to build a macro that: 1) Opens the...

www.mrexcel.com