How to extract external source to microsoft excel 2003?

how to i extract a value from an external source ( eg word document ) to insert into one box of microsoft excel and if the source changes value , the value in the microsoft excel changes value automactically ? im working with microsoft excel and word document 2003

another question ..

how do i do that internally ... example the cover page , one of the boxes have a certain value or text , i want the other pages to follow and similarly changes if the the value or text in the box changes in the cover page .

Please help ... !!! thanks ... if u have a guide for this please email me it ... ^^

How to extract external source to microsoft excel 2003?norton internet security

There are a number of ways that this can be accomplished.

It sounds like the users will be editing the MS Word Document so you will probably want to open the Excel Document on the open event of the Word Document. You can then use a VBA Macro to edit the data in the Excel Document.

Another way would be to write out the values to a file, like a csv file, from Word and then import these into an Excel file upon its opening.

Check out the link for some ideas and code samples on this.