+ Reply to Thread
Results 1 to 1 of 1

Need to search inside each highlighted PDF in the same folder as the Excel 2010 file

  1. #1
    Registered User
    Join Date
    10-24-2013
    Location
    Fort Wayne, IN
    MS-Off Ver
    Excel 2010
    Posts
    3

    Need to search inside each highlighted PDF in the same folder as the Excel 2010 file

    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:
    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.
    - 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!!!
    Last edited by alansidman; 01-25-2014 at 02:58 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to Copy cell value of all files which inside of folder and append to Master file
    By snsuvarna in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-06-2013, 03:38 PM
  2. search for a file in a folder based on data, copy and paste it in another folder
    By kboy1289 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2013, 11:47 AM
  3. Macro: Search for a file name in a specified folder and link to excel cell
    By jr13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-08-2013, 03:57 PM
  4. Search a word file in a specific folder and copy text to excel
    By corinereyes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2012, 08:15 AM
  5. Replies: 1
    Last Post: 10-02-2012, 04:27 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1