Further to our earlier response, we note the layout of the PDF report is not
consistent. Some places where zero entries are made as ".00" whereas some
places there is no entries at all. If this inconsistence can be rectified,
we believe the report can be converted to Excel with a little help from VBA
please.

Because MUN SHE CHE MHE tax have no entry, we have to adjust position of the
data.
But we trust the following conversion is correct.

NAME JOHNSON KAREN G
CO. 1
YR. 0
C/S# 15
ST.TAX 52.78
CO.TAX 354.03
MUN.TAX
FEES 10
INTER 21.35
AD.COST 18
OTHER 15
TOTAL 471.16
ASSES.CL 2
MUN.CODE 2
A.V. 8120
SHE TAX
CHE TAX
MHE TAX
OLD PARCEL NO. 0000000000000000000000
NEW PARCEL NO. 0121001430010320000100
DESCRIPTION LOT etc


"Mctabish" wrote in message
. ..
I recieve data every few weeks (about 65 files, each having up to 7000 or
so) that I need to evaluate. I want to work in Excel., but the data comes
in
a PDF format. I can not recieve data in anything but PDF (too simple, I
know)

The fields are fixed len, except the description field (second to last
feild) Each record wraps around 2 or three lines
I need to get each field into it's own cell. I probably could get it IF I
can figure out how to get each record into it's own row....

I have tried to save to TEXT from adobe. then opened it up under word and
tried to seperate at the records, but was not sucessful.


Here is a sample of one of the files:
http://www.johnsonclan.net/sample.pdf

Any help would be greatly appreciated!

Thanks,
Mc