Scan Excel Files and Find Differences

[bobgoblin12]

I have two directories one called Orig and one called New

Each one of these will have two sub-dirs, and should have the exact same file names, with the exact same contents on
Sheet1 - columns A - column BG
Sheet2 - columns A - column K
Sheet3 - columns A - column L


How can I se Excel VBA to compare each file in the Orig to the New directory and ensure that the file contents are the same?
If the file names and contents match 100% i'd like to add the file names to a worksheet called match
If the file names and contents do NOT match I'd like to add the file names to a worksheet called Error

 

[eiloken]

I have two directories one called Orig and one called New

Each one of these will have two sub-dirs, and should have the exact same file names, with the exact same contents on
Sheet1 - columns A - column BG
Sheet2 - columns A - column K
Sheet3 - columns A - column L


How can I se Excel VBA to compare each file in the Orig to the New directory and ensure that the file contents are the same?
If the file names and contents match 100% i'd like to add the file names to a worksheet called match
If the file names and contents do NOT match I'd like to add the file names to a worksheet called Error

what exactly do you want to compare with 2 files? just values or all contents like color, shapes,...?

 

[bobgoblin12]

@eiloken - compare the values

 

[eiloken]

@eiloken - compare the values

to convenience for compare 2 file, you should named its as different name because excel can not open 2 different files with same name

 

[JEC]

Not a problem if you read everything into variables and then close the files again.

Although the best way is to use power query

 

[eiloken]

Not a problem if you read everything into variables and then close the files again.

Although the best way is to use power query

yes, you can do that with class module for dynamic worksheet, but save as different name is easy to solve this problem

 

[bobgoblin12]

@JEC - how would I do it with Power Query?