Hello

I have the next question.
i have a workbook, and i would like to run a macro in it, which i can compare two files. I have the macro to the compare.But
i must open the file which i need to the comparasion and then search in it.
so far, i had always the same file name, which i opened.
now i have always different file (name) which i have to search.

this were the code, when my file name was always the same

keres = "'[pelda.csv]pelda'!$A$3:$A$1000"

now i first need to open a file what names are forexample 82 or 85 or 69 ...etc.
and then do the search. but i don't know how can i do this.