I previously wrote a small excel VBA program that compares the data in up to 5 different parameter matrixes and highlight the ones that differed

To do this I open all the files, I couldn't find any other way to do it

The problem lies in that many of these files are in different folders to identify the station, but have the same filename. I can't really change the filename because other programs use these files

My question is, can I open multiple workbooks with the same filename, or perhaps highlight these cells without having to directly open the workbooks

Thanks in advance

Matt Lawso