Thread: PDF to Excel
View Single Post
 
Old 12-13-2013, 07:58 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote