bill arvidson

attachment 4

attachment 3

attachment 2

posting indicates it will allow you to " Add attachments" but then only allows you to add one. here is what was to be #1

I have tried range compare. help file does not indicate how to fill in the fields. i do not know how to get the window that specifies to "stop on any miscompare". or how to continue / abort after finding a miscompare. when i tried the quick compare, it ran to completion but then left you with no way to find the first or any other miscompare. my file has anywhere from 28 thousand lines to 66 thousand. there should be a way to ask the tool to step to the first or Nth miscompare. I will attach a few...

Great, thanks. I have successfully done a compare. Database Compare Compare Completed. Took 9793.391 Secs. 4 cell(s) out of a total of 924437 cell(s) have changed (0%). got another error/warning while doing the above compare. Microsoft Excel Error 1004 (application-defined or object-defined error) in procedure CompareWorkbooks of form frmMain the compare tracking bar stopped around 47% - don't know if it is related. regards Bill

I am sorry for all the trouble. After reading the help file again and looking into the compare section, I realized I needed to independently open the 2 files to compare then invoke the full compare add on. i no longer get the invalid property value error. and it appears to be comparing. it is only 11% done - update later when done. thank you for all your help Bill

tried to put 2 attachments, but only 2nd one was sent. here is the 1st.