I was hoping to develop a macro that extracts specific values from
fairly well sturctured reports in MS Word (Roughly 1000 of them). I do
not expect any miracles, but was hoping to be able to pull out a few
specific values.

Simplified Example report format:

Review No: ########
Code: #####
Title: Aaaaaa
Type: ###

(text)

I could mostly likely key in on the field headings (e.g., Review No:)
and take the next 7 numbers. But I was hoping to run through the
documents with a little more flexibility.

Any feedback on this matter or available open-source or commercial
tools.

Thanks

Hi Matt,

If the data you want to keep don't use the same paragraph style as the data
you want to delete, you could use a Word macro to go through the file,
deleting all paras in the unwanted styles.

That would leave just the data you want for copying & pasting into Excel.

Cheers


"Matt" wrote in message
oups.com...
I was hoping to develop a macro that extracts specific values from
fairly well sturctured reports in MS Word (Roughly 1000 of them). I do
not expect any miracles, but was hoping to be able to pull out a few
specific values.

Simplified Example report format:

Review No: ########
Code: #####
Title: Aaaaaa
Type: ###

(text)

I could mostly likely key in on the field headings (e.g., Review No:)
and take the next 7 numbers. But I was hoping to run through the
documents with a little more flexibility.

Any feedback on this matter or available open-source or commercial
tools.

Thanks

You could have the macro search for the title, colon -and- space, then
have it jump to the end of the next word (ctrl+rt.arrow), instead o
always moving *-n-* characters past the title. That way would give
little flexability in the length of the selection.
-------------------------
Ben :cool

--
protonLea
-----------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...fo&userid=3209
View this thread: http://www.excelforum.com/showthread.php?threadid=53823