Hello fellow forumites. Trying to figure out how to automate word. I saw that someone has DOCVARIABLES which are linked to Excel fields and I am trying to figure out how he did it.



The reason I don't want to use paste link is that it uses a row/column reference and if a row or column are added it messes the other fields.

Basically, the fields look like this:

{ DOCVARIABLE "Address" \* MERGEFORMAT }

Now with the above field inserting rows and columns does not make a difference.

Presumably 'someone' has used a macro either in Word or Excel to populate the docvariable with the data from the worksheet. There is no 'linking' involved.


As for your requirement to automate document creation, then what exactly are ytou trying to achieve. Maybe https://www.gmayor.com/Userform_ComboBox.html will help?

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com