Hi Nancy,
As I have said, there are different ways of updating your document.
Quote:
|
A macro is only one possible way. The fact you seem to be doing a lot of this suggests that mailmerge or OLE (linking) might be a better solution.
|
Until you tell me more about how you are using the document, I am reluctant to give you a solution that might be done more efficiently another way.
Quote:
|
For example, if you are trying to produce multiple documents at a time, mailmerge may be the way to go. Alternatively, if it's essentially the same content in a single document being updated on a regular basis, OLE (linking) may be the way to go.
|
The macro in this link
https://www.msofficeforums.com/vba/1...o-problem.html shows how one might go about updating a Word document from an Excel file. It would need some changes before it could be used for your purposes but, as I've already said, there may be a better way. Some 80% of the code in that link is needed just to manage Excel.