I am opening several excel files in a folder and then compare the said file on another file on a different folder. So i thought i could do it like this since those 2 files has almost the same filename only differs on date.

Ex.
Folder1
Tokyo_201204_Generic.xls <----this is always the format of the filenames City Name _ Date _ Generic
Hiroshima_201204_Generic.xls

Folder2
Tokyo_201205_Generic.xls
Hiroshima_201205_Generic.xls

So if I open [Tokyo_201204_Generic.xls] I need to compare it to [Tokyo_201205_Generic.xls]. To be able to do it I need to get "Tokyo_" and compare if there is a file on folder2 with filename that starts with "Tokyo_". I can't include the date to the comparison since the date varies every month. Folder1 and Folder2 paths are user inputs. How do I do this with macro?

Any help would be greatly appreciated.