Importing pdf file into Excel

  • Thread starter Thread starter David
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top