Importing pdf file into Excel

D

David McRitchie

Hi David,
See http://www.mvps.org/dmcritchie/excel/pdf.htm
I think you will have to create a .CSV file or an html file.
as an intermediary using the full Acrobat package,
or with free software like PDFedit. You can do something
with the free Acrobat reader but it means copying one column
at a time.

Going through HTML rather than .CSV should pick up interior
color formatting. If you end up with extra spaces you can try
my TrimALL macro
http://www.mvps.org/dmcritchie/excel/excel.htm

Please provide feedback on how this worked out (or didn't work) for you.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Top