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.
Hi Ahmed,
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.
