I want to use ExcelVBA to search for words in newspaper PDF data, and if it hits, I want to extract PDF data that hits the search word into Excel.

Asked 1 years ago, Updated 1 years ago, 396 views

I use Acrobat Reader Pro to write in VBA, but it doesn't work.
I tried to extract the PDF to Excel after XML conversion, but I couldn't because the XML file didn't translate the contents of the newspaper well.

I would appreciate it if you could give me a rough idea.
Also, I would be even happier if you could attach the code.

Thank you for your cooperation.

vba pdf

2022-09-30 21:58

1 Answers

I've built the entire system as a business tool. Where are you struggling?

Basically, pdf=>xml=>1 pdf or 1 page full text string in an array
=>Write all stored items to another file and store them=>Run search for stored files
=>List the appropriate line = file (or page) number as a return value.

You can do it in a way, but I don't know if xml doesn't work because it's a garbled character code or just a messy text storage order.

Generally speaking, VBA management is quite heavy, so it is recommended to replace some processing with local PC-operated html + Javascript to avoid CPU load and application occupancy.I was half traumatized.


2022-09-30 21:58

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.