Hello all,
I am very new to excel vba and this may look trivial so please bear with me. I have two text files containing numbers each with one column. I need to compare each line in the first file with all the lines in the second file. The files do not contain the same number of lines. If the difference of a line is less than a certain number I would like to write the differences to another file. The output file may be larger than the smaller file. The actual files are pretty large but I can supply a set of files with fewer lines for testing. Thanks in advance for your help.
Emin
I am very new to excel vba and this may look trivial so please bear with me. I have two text files containing numbers each with one column. I need to compare each line in the first file with all the lines in the second file. The files do not contain the same number of lines. If the difference of a line is less than a certain number I would like to write the differences to another file. The output file may be larger than the smaller file. The actual files are pretty large but I can supply a set of files with fewer lines for testing. Thanks in advance for your help.
Emin