Hi,

I am trying to create a summary document of data held in a table at the
start of many word documents.

When a person modifies one of the many word documents they are asked to
fill in 4 cells of the table at the top of that document, recording the
changes.

I tried to record a macro to copy the cells I wanted and paste them
into a summary document in excel, so the user would simply have to
press a button to submit the information they added, to the summary
document.

However, i was unable to select cells of a table in the "record macro"
mode. I then inserted an excel spreadsheet into word for users to log
their changes, so I could reference the cells, but I could not edit the
spreadsheet in "record macro" mode either!

I have also tried creating a linked object but could not make that work
either!

I dont mind whether the summary document is in excel or word format (i
just thought excel would be easier to write to) or whether the table in
the word documents is a table or spreadsheet, could you please suggest
a way of copying the added information in each of the many tables when
a user edits the documents to a summary document??

Thank you!

Tory


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/