VBA- copy/paste data from a non-standard file extension

[Js Smith]

Hi! I'm back trying to automate more menial manual data processing.

We have files from a vendor where they create txt files then add a .date extension at the end. I.E. on April 2 we got a file called data_file.txt.20230331and on May 22 we got a file called data_file.txt.20230519
I can't figure how to get at the data in these files to start manipulating it.
How do would you use the Application.GetOpenFilename() function to open these files with bad extensions and extract the data?

Once the data is in excel, I'm good to go. Thanks for your advice, as always!

 

[dashiellx]

Honestly, I'd ask the vendor to change the way they name files. It's odd to have the date in the extension and not within the file name itself. i.e. data_file.txt.20230331 should be data_file_20230331.txt

If that is not possible, I'd look at renaming the files and then importing.