Results 1 to 6 of 6
  1. #1
    gregormat
    Guest

    Excel and Adobe Acrobat (Excel97/Adobe Acrobat 5)

    I was wondering if it is possible to take a PDF file from Adobe Acrobat and bring it into a usable format within Excel?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Excel and Adobe Acrobat (Excel97/Adobe Acrobat 5)

    gregormat

    PDF documents are usually uneditable. This is the whole idea behind PDF documents.

    But you can do some minimal edits if you have the Adobe Acrobat suite, Acrobate Exchange in particular. Exchange may help you in editing the PDF document but don't expect to change a number to a chart.

    Adobe Distiller will make your PDF documents, by simply creating a Postscript file and then distill that file.

    I suggest if its not too political is to ask the sender to send it to you in MS-Excel format, or recreate the work. Its less time and effort consuming.

    HTH

    Wassim <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    gregormat
    Guest

    Re: Excel and Adobe Acrobat (Excel97/Adobe Acrobat 5)

    Wassim,
    Thanks for your reply! Actually, what is happening is.... I am receiving a report (hard copy) from a person that is unable to provide me with a soft copy. So I scanned it, and created a PDF file of the report. What I really need however is the report in Excel format. I used Adobe Capture to convert the PDF file to a format that allows me to copy the contents, however, when I paste it into Excel, it is all over the place. Any ideas?
    Greg

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel and Adobe Acrobat (Excel97/Adobe Acrobat 5)

    There is no easy solution, but see <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=off&Number=37751>this thread</A> for some ideas.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel and Adobe Acrobat (Excel97/Adobe Acrobat 5)

    What you need to do is to scan the document using Optical Character Recognition software (OCR) to convert the document into a text file, not a PDF file.
    Legare Coleman

  6. #6
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Excel and Adobe Acrobat (Excel97/Adobe Acrobat 5)

    gregormat

    As Legare had mentioned you need to have an OCR scan. This will probably be 100 times easier to re-edit to get it to look like the original.

    I suggest to ask the person who delivers the report in hard copy to ask the person who gets him the report if he can provide it in Excel format. Someone some where has to produce this report, and there is where you need to ask.

    Alternativly if you can produce a mock up of the general format of the report, and then plug the changed info then you have done a good job.

    Basically what I am saying is that when ever you are mixing digital and analog media, the results are not as good as you would expect.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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