I appreciate your information Michael, but that stuff is 'way over my
head......no matter tho, the problem was just solved......

Many thanks for your response....

Vaya con Dios,
Chuck, CABGx3


"Michael Bednarek" wrote:

On Mon, 14 Feb 2005 07:35:03 -0800, CLR
wrote in microsoft.public.excel.programming:

I can record a macro and do this completely as I want to,.......that is,
open the PDF file from within Excel, get Acrobat Reader to then open it, and
copy and paste all text (as a flat column A text) into my Excel
sheet............only problem is, the Copy and Paste steps do not
"record".......

If anyone knows how to do this, I would dearly appreciate the help.

I do something similar by extracting the relevant information from the
PDF file with pdftotext from <http://www.foolabs.com/xpdf/ and
subsequent batch-editing. For that I use 4NT's string manipulation
features, but sed or similar would probably do it as well. The resulting
file can then be imported as a CSV file.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"