Obtain Word Doc Info Into Excel
 

Hello. I am using Excel 2000.

I am very grateful for all the help I've received here and now I'm
asking for
your help concerning gathering information from a Word doc into Excel.

I wonder if it is possible to "capture" data from a Word doc and save
it into an
Excel Sheet, thus preserving a "database" of the user's inputs over
time. Specifically . . .

Idea 1 : If a Word doc existed with a Table of 10 columns and 8 rows,
could the entire contents of those 80 fields be saved as a single
record (row)
in Excel ? That is, into the next empty row on Sheet 1 from columns A
to CB
(which is 80 columns wide). What VBA code could open the Word doc,
obtain the 80 fields of data and copy it into Excel ?

Idea 2: Very similar. If a Word doc existed as a Word Fill-In Form,
say
with 25 distinct fields, could such data "capture" also be accomplished
into
Excel as mentioned above, via VBA ? That is, all 25 fields as a single
record
in Excel, beginning with column A, at the next available empty row.

I know in Excel one means of transferring values is like the code line
below.

Range("Sales!C12").Value = Range("Inventory!M35").Value

(The code above gathers the value from cell M35 on the Inventory Sheet
and places
it into cell C12 on the Sales Sheet. I am assuming there should be some
similar
syntax to obtain field data from Word into Excel.)

If this is possible, I would appreciate any coding help along these
lines.

Thank you very much.

WayneK


--
WayneK
------------------------------------------------------------------------
WayneK's Profile: http://www.excelforum.com/member.php...o&userid=23037
View this thread: http://www.excelforum.com/showthread...hreadid=388413