+ Reply to Thread
Results 1 to 7 of 7

List page numbers of an Adobe PDF file that contains highlighted text

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    List page numbers of an Adobe PDF file that contains highlighted text

    I currently have Excel 2013 and Acrobat X professional. I have received a large PDF file with various sections in multiple pages highlighted with the Acrobat highlight text tool. Is it possible for Excel macro to scan the PDF and list all page numbers only that contain highlighted text?

    There is an option in Acrobat to make highlighted text into comments and then extract those pages, but prefer an Excel option where I get a workbook with the page numbers listed. Any info is appreciated.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: List page numbers of an Adobe PDF file that contains highlighted text

    Hi Brawnystaff,

    If possible, please upload a sample .pdf file that contains at least two pages with highlighted text.

    Lewis

  3. #3
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Re: List page numbers of an Adobe PDF file that contains highlighted text

    See attachment below. Thx.

    TestDocument.pdf

  4. #4
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: List page numbers of an Adobe PDF file that contains highlighted text

    Hi,

    Unfortunately, I was unsuccessful. I have two pdf tools that I thought I might be able to use:
    a. PdfTk - https://www.pdflabs.com/tools/pdftk-server/
    b. PdfToText (X86, Windows Binary) - http://www.foolabs.com/xpdf/download.html

    Both are command line tools that I am able to run from Excel.

    --------------------
    I was able to find a web based program that does exactly what you want, but I'm pretty sure it's not the solution you want: https://www.sumnotes.net/index.php

    You have to register to extract the highlights to a text file.

    I'm sorry I couldn't have helped more.

    Lewis

  5. #5
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Re: List page numbers of an Adobe PDF file that contains highlighted text

    Thanks LJMetzger for looking.

  6. #6
    Registered User
    Join Date
    11-08-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: List page numbers of an Adobe PDF file that contains highlighted text

    Acrobat can generate a csv file that I will do what you want, if I understand correctly. I use is quite often for a similar purpose. You need the Create Comment Summary action, which you can obtain here: https://acrobatusers.com/assets/uplo...nt_Summary.pdf

  7. #7
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Re: List page numbers of an Adobe PDF file that contains highlighted text

    Thanks ShirlyP. Did not realize that listing comments also meant highlighted text, but apparently it does.

+ 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] Extract Pages from Adobe PDF based on Page Numbers
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-23-2020, 01:04 AM
  2. Yes/no drop down list needs to populate a contents page with matching page numbers
    By limebaish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2013, 02:46 PM
  3. Output of Highlighted Rows to Text File
    By KenB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2008, 10:45 PM
  4. Replies: 1
    Last Post: 11-02-2005, 06:17 PM
  5. [SOLVED] Scaling Page with Adobe PDFwriter 7.0
    By Will in forum Excel General
    Replies: 0
    Last Post: 10-04-2005, 03:05 AM

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