Open file and find a value in it

[stimea]

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.

[wallyeye]

You can allow the user to browse for a file name:

Please Login or Register  to view this content.

If you have a set folder but not a set file, you can do something similar by looping through all the files in a folder. Post back if you need something different.