Hi, I'm fairly new to this site - thanks in advance for your help!
Using Excel 2010, I want to use VBA to ask the user to highlight a number of PDF's to search in the same folder as the Excel file running the VBA program.
They might select 1-10 PDF files in the folder. Then, I want to ask them for a text string to search. Then, I want to loop through each of those highlighted PDF's searching for that string/text and when found then to tell them the file name and page number, and then print that specific PDF page.
Any help you can offer for any portion of this would be greatly appreciated - thanks!!!
I've spent a couple of hours searching on the web and haven't been able to get over this hurdle yet...
I'm having issues opening the PDF files using:
and
- am getting Run-time error 429 "ActiveX component can't create object"
Inside the VBA Editor, under Tools>References, I do haveI do have the "Adobe Acrobat 10.0 Type Library" and "Acrobat Access 3.0 Type Library" selected. I am running this on a Windows 7 PC using Adobe Reader XI, version 11.0.5.
I suspect that I can use "ActiveWorkbook.FollowHyperlink FileNameStr" in a loop, and replace the FileNameStr with the next file somehow, but do not know how to search the PDF once it is open and then to identify the page #, print the page, etc.
Thanks in advance!!!
Bookmarks