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]

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:

those are the texts that I have to locate inside the PDF document...

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]

That's a good suggestion. I am not as familiar with data queries, but some very powerful features have been added in recent years.

Also, PowerQuery may be able to do this (but I am not experienced with it).

Just speaking as another member, providing "Prefer not to say" for Excel version will cause a lot of confusion when people give you solutions that might not work in your version. I've never seen anyone not want to offer that information.

Hi Jeff,
Thanks again for your contribution...
I agree with you, regarding to the excel file info's But I mentioned that the PDF file is under information control & protection by the owner. If sharing the excel sheet will helps to create a solution for my question, I am appreciate and sharing the sheet with pleasure.
Regards,

 

[gonjin]

Just give a try and see how data is populating since it is searchable,

View attachment 124138

Hi Sam,
Thanhks for your help and suggestion
Unfortunately, did not working. See below the responde from Excel installed in my laptop:

Still looking for a solution for my case...
Regards,

 

[hungtbatman1]

Hi Sam,
Thanhks for your help and suggestion
Unfortunately, did not working. See below the responde from Excel installed in my laptop:

Still looking for a solution for my case...
Regards,

Can't you install another app? IT won't let you?

 

[Sam_D_Ben]

If sharing the excel sheet will helps to create a solution for my question

Yea, go ahead, please share the Excel sheet

 

[6StringJazzer]

I agree with you, regarding to the excel file info's

My point was regarding your user profile, not your Excel file. We don't know what Excel version you are using, so whatever we tell you to do may not work on your version.

 

[gonjin]

Can't you install another app? IT won't let you?

Hello!
Unfortunately no. I do not have admin privileges to do any changes in the apps installed on this laptop...
Hugs,

 

[gonjin]

Yea, go ahead, please share the Excel sheet

Hi,
How can I up the excel file in this chat? I did not found the icon for upload the xlsx file....
Thanks in advance for your guidance to up the file here...
Hugs,

 

[Sam_D_Ben]

Hi,
How can I up the excel file in this chat? I did not found the icon for upload the xlsx file....
Thanks in advance for your guidance to up the file here...
Hugs,

Or drop a screenshot of your excel file just to get an idea.

 

[gonjin]

My point was regarding your user profile, not your Excel file. We don't know what Excel version you are using, so whatever we tell you to do may not work on your version.

Hi Jeff,
Follow the info's regarding the excel version that I am using:

Hugs,

 

[gonjin]

Or drop a screenshot of your excel file just to get an idea.

Hi,
Follow:

Hugs,