Macro to find most recent csv file in folder and import this

[electros]

Hi, I'm new to excel and VBA but I have a problem at work you do not know how to fix it.
In one folder we have several files titled as below

CoduriEAN01-Jun-15.csv
CoduriEAN02-Jun-15.csv
CoduriEAN04-Mai-15.csv
CoduriEAN06-Jun-15.csv

I would like to run a macro to check that the files have more recent date in name and to import In one new tab.
Code must check only files that have the name "CoduriEAN**" because in that folder are other .csv file with another name but those they date in name.

I enclose a csv file to see what has to be imported.
Thanks in advance for any ideas and apologize if I did not write properly in English.

[Leith Ross]

Hello electros,

Welcome to the Forum!

How would you tell which of these 3 files is most recent?

CoduriEAN01-Jun-15.csv
CoduriEAN02-Jun-15.csv
CoduriEAN06-Jun-15.csv

NOTE: Never mind, I see it now. Need more coffee!

[Leith Ross]

Hello

Try this macro out. Hopefully VBA will not have problems with the dates. Change the folder path in the macro to match where your files are.

This macro will scan the folder for most recent csv file starting with "CoduriEAN". The file date is extracted from the file name and the most recent date and file name are saved. Once all files have be checked, the most recent file will be opened in Excel.

Please Login or Register  to view this content.

[electros]

Thanks for the reply but the code does not work posted.
I give me the error in the first screenshot, and when I hit debug are posted on the yellow line in the screenshot two
Please help me

[electros]

I resolved the error, I modified this line of code

Please Login or Register  to view this content.

as shown below

Please Login or Register  to view this content.

and now works as you said, but not as I would like. I do not want to open csv file again In one document but I want it to be imported into the active document in an existing sheet called "CoduriEAN" for example

Please help

[Leith Ross]

Hello electros,

This macro will work with data based on the examples you posted. If your actual data is different then I can not guarantee it will work as intended.

Please Login or Register  to view this content.

[electros]

Hello Leith Ross
Thanks for your answer but posted code does not work for me.
I give me the error in the image below and do not know what to them.

[electros]

I solved the above error,was the regional settings. I put the English(US) and now works but if in this directory is a file from 2014 (for example CoduriEAN31-Mar-14.csv).It can be set to search only the current year?
P. S.
I have tested and found that this code only check day which is higher and picks it.Do not check the month and year.This code is not correct for me. It should check all files of this year and this month and to choose the most new. This folder contains files from 2013 and 2014 and of course the 2015 that I am not allowed to delete them.