September 30, 2021
Hello excel experts,
I need some help with excel macros.
I'm looking for excel VBA Code to open pdf/word/xls file based on the hyperlink in column L, and search the opened file content for the "version" and return the version number next to word "version" within the searched file and add it to column E. usually version is in the footer of the pdf/word/xls file.
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013
Each application needs a different search method.
What are you using to open PDF files? Do you have Acrobat or the free reader only? Are those PDF's containing text or images of a text (if OCR was run in that file, text is already identified)
What excel version you have? If you use M365, you have the possibility to import PDF's data into excel, then use excel tools to find what you need.
Lots of questions, please provide more details of your environment.