Thank you!Can I update a word doc and have the information save on a spreadsheet?My suggestion is that, rather than try to make word update excel (which, frankly, would be a nightmare), have excel update word (easy).
I think what you need to do is use the mail merge feature of Word with the Excel spreadsheet as your data source (the place it pulls the data from to insert into your document).
Since it's a little tricky to set up I would suggest looking through google for advice on how to use an excel spreadsheet in a mail merge. Once set up, however, the operation is very simple. It would also be easier to update the spreadsheet by hand and send the info to Word than the other way around.
If you really want it to work the other way around (Word to excel), I would suggest looking up how to link a data field to excel.
I hope that this helps you.Can I update a word doc and have the information save on a spreadsheet?Yes, you can make a macro that will do it for you.
Here is a link to one I found online, but it saves the changes to a new word document.
http://www.thedoctools.com/index.php?sho鈥?/a>
This can be easily modified to add it to an existing Excel spreadsheet if you know VBA.
No comments:
Post a Comment