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.

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

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656