Re: Importing pdf file into Excel
From: David McRitchie (dmcritchie_at_msn.com)
Date: 05/13/04
- Next message: Andy B: "Re: converting numbers into a date"
- Previous message: Frank Kabel: "Macro functions on exit"
- In reply to: David: "Importing pdf file into Excel"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 13 May 2004 03:59:47 -0400
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
"David" <LaBedzD@tacom.army.mil> wrote in message news:ad4f01c436a0$d7f93fc0$a501280a@phx.gbl...
> Any way to easily import a pdf file into Excel?
- Next message: Andy B: "Re: converting numbers into a date"
- Previous message: Frank Kabel: "Macro functions on exit"
- In reply to: David: "Importing pdf file into Excel"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|