New Member
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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
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.
1 Guest(s)