Hi
I need to make a comparison between two files with some sheets. the files come from external files (not Excel) .
because the folder names are not fixed , change there name to "File 1 " and "File 2 ".
Now I need a macro that could do a comparison (eg check whether the first cell in the first file equal to the first cell in the second file ), but the problem is there is no fixed sheets names.
Is there a way to do this (eg set up something like the first sheet , second sheet, etc.)?