Posting Data from word into Excel

[Newgroups]

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

 

[Astrid]

Hi Mike,

The answer to this one depends on where your data in the document is stored. You could use automation to write from Word to Excel. For starters see the info at
http://www.mvps.org/word/FAQs/InterDev/ControlXLFromWord.htm

Hope this helps,
regards,
Astrid

So that all can benefit from the discussion, please post all follow-ups to the newsgroup.
Visit the MVP Word FAQ site at http://www.mvps.org/word/