I don't want to highlight the text in excel, I want to highlight it on the PDF. Some of the vbs that I saw involved finding text letter by letter and then drawing rectangles around it and colouring with javascript and that just seemed unnecessarily complicated (couldn't get the port to work anyway.). I've got adobe acrobat X, so there must be some sort of API that will allow me to do this with excel vba? Am I going to have to use some sort of opensource library like iText I would prefer not to. What I'm trying to do is open up PDF docs, search them for keywords and then highlight those words and save. I have managed to import the pdf text into sheets and search it, which is good but this won't allow me to actually highlight the pdf obviously. Found some vbs that I tried to port over but no luck. Right, so after hours of searching I've come up with nothing for excel vba, which I find surprising.
0 kommentar(er)
