How to detect a string text in a pdf file and return in excel the location of the string (i.e. pdf page number)

gonjin

New Member
Joined
Apr 4, 2025
Messages
10
Office Version
  1. Prefer Not To Say
Platform
  1. Windows
Hello fellows,
I work with some drawings in .PDF format and I have been tried to identify some text string, comparing the info that I have in excel sheet with the info on .PDF file, as shown below:
1743791013527.png
those are the texts that I have to locate inside the PDF document...

1743791148934.png

the same information in the excel sheet are shown above in the PDF document (drawing), surrounded by the red pencil....
I am using the 365 apps and Adobe Acrobat Reader (not Pro). The applications softwares are under IT governance by the company that I've been working in the moment, so I have limitations for implement some customization...
What I desire to do is to identify the texts that I paste above (column from excel) in the PDF example and have another column in excel, with the page number of the texts that could be located, as a manner to validate the information.
Can someone helps me in the VBA and/or a solution for that, please?
Many thanks in advance!
 
@gonjin , Please extract this specific image page from the PDF as it is and provide it as a downloadable link, Cause If the PDF is searchable, Excel's Get Data feature should be able to extract some content. I tested it with a sample PDF that isn't fully searchable, and this is what it looked like.
1744048239574.png
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top