+ Reply to Thread
Results 1 to 2 of 2

Can I create an excel macro to search & extract certain information from a pdf file?

  1. #1
    Registered User
    Join Date
    10-10-2011
    Location
    Toronto Canada
    MS-Off Ver
    Excel 2010
    Posts
    1

    Can I create an excel macro to search & extract certain information from a pdf file?

    Hello,

    I am new to Excel and was wondering if there is a way to create a macro for my situation.

    I am recording voting decisions from a Adobe pdf file into an excel spreadsheet. I need to go through multiple pdf files and find the pages where votes have taken place. The picture attached shows a vote circled in red.

    I then need to record the following information into an excel spreadsheet:
    1) The number of 'yes' votes and the number of 'no' notes
    2) The names of the people who voted yes and the names of the people who voted no
    3) The pdf page number of the vote recorded

    I would like to compile all of the information in an excel file for later use in the statistics software spss.

    There are hundreds of individual votes I need to record and would love it if someone can help guide me in creating a macro for this tedious project.

    Thank you!
    Attached Images Attached Images
    Last edited by razabear; 10-10-2011 at 07:23 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Can I create an excel macro to search & extract certain information from a pdf fi

    I doubt it
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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