I'm dealing with a huge Excel spreadsheet, containing 61 worksheets.
Now, I've just received a newer file, and I need to compare them to see what's changed.
To compare them I'm using
a software called 'Beyond Compare', but unfortunately as far as I know, this software only compares the active worksheet.
One solution that would still eat up quite some time would be to export each worksheet automatically into
tab-delimited text files.
I've got two questions:
1. How can I export each worksheet automatically into separate text files? I guess I probably need a macro, and I have no
clue on how to create it.
2. These files are in Japanese. I need to export the text in one of the following
If there's no way this can be achieved like this, do you know if it's possible to directly encode the Excel
file itself into one of the 3 codifications above?
I can see that I'm not asking easy questions, but hopefully
some of you Excel-genius can help me out.
Thanks very much
Edit: And of course, do you know a better
way to compare these two spreadsheets?