+ Reply to Thread
Results 1 to 5 of 5

PDF to Excel - VBA Support needed.

  1. #1
    Forum Contributor lifeisaspreadsheet's Avatar
    Join Date
    10-04-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    208

    PDF to Excel - VBA Support needed.

    Hello everyone!

    Request is to convert the PDF into Excel. I have 250 such PDF pages (sample attached). The output needed is:

    Column 1 (Book Name) of the PDF in Column A
    Column 2 (Name) of the PDF in Column B
    Column 3 (K No) of the PDF in Column C
    Column 4 (SQ No) of the PDF in Column D

    I tried several online PDF to Excel converters, but they don’t seem to be working in the desired manner so I’m requesting some VBA help.

    Thanks!
    Attached Files Attached Files
    Experience is not what happens to you; it's what you do with what happens to you.

  2. #2
    Forum Contributor lifeisaspreadsheet's Avatar
    Join Date
    10-04-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    208

    Re: PDF to Excel - VBA Support needed.

    Could someone please assist / help me on this please....Thnx

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: PDF to Excel - VBA Support needed.

    That's a scanned PDF. You could try to OCR it with Acrobat, but the quality is so bad and the writing so illegible that it's likely to be a miserable failure.

    Think you need to start typing.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Contributor lifeisaspreadsheet's Avatar
    Join Date
    10-04-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    208

    Re: PDF to Excel - VBA Support needed.

    Hmmmm....anyother thoughts, inputs or help with a solution by anyone else please...

  5. #5
    Registered User
    Join Date
    08-13-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    87

    Re: PDF to Excel - VBA Support needed.

    Quote Originally Posted by lifeisaspreadsheet View Post
    Hmmmm....anyother thoughts, inputs or help with a solution by anyone else please...
    Hello,
    Did you get a solution for this? I am also looking to convert a PDF into Excel, mine is not handwritten but an output from a software.



    Thanks,
    Aadesh Gandhi

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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