Shane, it may seem a second-best solution to you, but if you were planning on writing a VBA program to modify the worksheet, why not have the program also clean up the translation as well? Surely whatever problems you find with any one translation utility will occur the same way every time, right? So a VBA program should be able to run the translation, open the result, look through the resulting mess, pick out the part of the data that you actually want and do the updating that you wanted in the first place.
As a bonus, the VBA program could also fetch the latest copy of the PDF from the internet—one less step for the user.
|