Posting Data from Word into Excel

[Mike]

I want to create an automated way for my users to post data into an excel
spreadsheet from a word document.

Currently that spreadsheet is used as the data source for a mail merge
document. I want the data to travel in the opposite direction. The user
should be able to enter the information in specific fields within the
document and then have the data post to the excel spreadsheet. The data
stored in the excel spreadsheet then could be referenced at a later time.

Any ideas on how to accomplish this?

TIA
Mike

 

[Doug Robbins - Word MVP]

Hi Mike,

See the article “Control Excel from Word” at:

http://www.mvps.org/word/FAQs/InterDev/ControlXLFromWord.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP