Right so the problem is as follows if anybody could give me a few pointers:
I've what seems like a simple task to do. I'm coding in VBA and want to run a macro such that you identify two folders (each contain the same number of files, with the same name).
I then want to compare these files(.txt, .xls, .exp, .tab - Issues with file types?) whether that be by parsing the files or by loading them into excel in a temporary sheet, pair by pair and doing some sort of vlookup.
The point of this is to find any discrepancies and highlight them in a seperate sheet for further analysis. (can the FC function in DOS help at all?)
If anyone could point me in the direction of a VBA method or a starting point I would greatly appreciate it. Thanks in advance.
Bookmarks