Importing from PDF

**RIFRAF** · 11-08-2006, 03:06 PM

Is there a way to import from a PDF file?

**Carim** · 11-08-2006, 03:10 PM

Hi,

No ...
But If the data is selectable, you can view it in Acrobat reader, select the
data, copy it, paste it into Excel.

HTH
Carim

**VBA Noob** · 11-08-2006, 03:20 PM

Hi, Just to add to Carim comments

Copy/Paste from the PDF document into Excel frequently works if its organization is not overly complex and variable. You may need to use Excel's
Data > TextToColumns afterwards to break it into separate columns - or you may not.

Alternatively OCR software can frequently read in PDF files and output Excel
data that is properly tabled and requires no further manipulation. AbbyyFine is one but there are other programs out there too

http://www.abbyy.com/

VBA Noob

**RIFRAF** · 11-08-2006, 03:29 PM

Thanks for your suggestions

**acc58** · 11-15-2006, 02:56 PM

It is very easily done,

download "able2extract".

Just open a file (pdf), and press the E button and all of the data goes into a new excel sheet. Very efficient and cool.

AC

Importing from PDF

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Importing from PDF

importing

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions