Loop through a set of files and check if a file doesn't exist

Hello everyone,

I am struggling with this the last days so I would appreciate if you could help me. My problem is that I want to loop through a directory that contains csv files. The directory is dynamic so everytime could be a different number of files inside. I want the loop to go through each file and check if that file exists. If it doesn't to print a message that this specific files doesn't exist. Until now I got the following code:

Please Login or Register  to view this content.

I guess I should somehow place the counter j inside the Dir path in order to check if everytime time the file[j] exists?

Thank you in advance

Try changing & "\*.csv" to & "\" & j ".csv"

Thanks for the reply i did this :

Please Login or Register  to view this content.

but there is a compile error->Expected list separator or ) at the ".csv" part

Because how can I check the missing file ? I mean, if for example i got 10 files and the 05.csv is missing , don't I have to loop first to see how many i got in total and then find the missing one? I don't know, I agree the code is bad but i am trying it to do it step by step.

Thank you very much for the explanation. I think I got it know. Thanks again!