Hello everyone,
I don't know if I ask too much, but is it possible if I have a directory like the following
Sub Import()
Dim strFile As String
strFile = Dir(ThisWorkbook.Path & "\*.csv")
End Sub
with .csv files which are placed in arithmetic order 01,02,03 etc to determine if one .csv file is missing and print an error that this file is missing? I think that if I knew how many files I got I would create an array and check one by one the files.. But in case I have a dynamic directory and the number of files is not the same all the time , is this possible?
Thank you in advance,
Desolatori
Bookmarks