VishalkumarT
04-18-2007, 01:47 AM
Dear friends,
I have posted one querry here before few days and got the best reply in short time.
Thanx a lot for the same.
I hope to have it this time as well.
My querry is, I want to compare two Excel workbooks, having some (for example 10) worksheets in each, with same format (same number of row/columns and style of data store in it).
But this time due to typical data processing methods, I want to compare them in a different way.
I want to CONVERT these two workbooks into text files (with proper tabs/spaces for columns and so, for all worksheets in them), COMPARE these text files in some softwares like UltraEdit or Araxis Merge (which I found in Internet), GET the comparison text file with proper result (cell differences and/or lines-or-rows added and/or lines-or-rows removed, in all worksheets) and in the end, CONVERT this resulting file BACK INTO excel, to see the differences/result in the excel environment only.
Is there any possible way which can be suggested here to solve this problem ?
Thank you for your replies in advance.
Best Regards
Vishalkumar
P.S. Thanks Simon for your reply of my last post.
I have posted one querry here before few days and got the best reply in short time.
Thanx a lot for the same.
I hope to have it this time as well.
My querry is, I want to compare two Excel workbooks, having some (for example 10) worksheets in each, with same format (same number of row/columns and style of data store in it).
But this time due to typical data processing methods, I want to compare them in a different way.
I want to CONVERT these two workbooks into text files (with proper tabs/spaces for columns and so, for all worksheets in them), COMPARE these text files in some softwares like UltraEdit or Araxis Merge (which I found in Internet), GET the comparison text file with proper result (cell differences and/or lines-or-rows added and/or lines-or-rows removed, in all worksheets) and in the end, CONVERT this resulting file BACK INTO excel, to see the differences/result in the excel environment only.
Is there any possible way which can be suggested here to solve this problem ?
Thank you for your replies in advance.
Best Regards
Vishalkumar
P.S. Thanks Simon for your reply of my last post.