Dear all,

I am struggling for days with the following problem. Many threads exist on this topic in this forum and on other websites, but the proposed solutions simply don't seem to work.

In my company we use several word templates (up to 30). In order to prevent that a new user has to manually open each template to add his user details (name, title, unit location, phone number, email, ...) I want to work with one document "User Information" to which the destinated fields in the templates link. So that the correct user information is added automatically when the template is opened. The linking works without a problem. I simply use copy and paste special as a link.

I have chosen for word (instead of excel) given that I find it to be the most user friendly (especially with the forms we use). In addition word is the best accessible for the many computer illiterates at my company.

The problem is that I keep having two annoying issues:

1) when I open the template I want to use (which opens as a normal docx. document) I receive each time the information that the document contains links to other documents and whether I want to update the information. I want this message to stop appearing and that the links simply automatically update.

What I already tried:
- in advanced settings: tick the box for automatically updating links
- using several macros, in particular the ones from this topic: https://www.msofficeforums.com/word/...matically.html

In vain, the same message keeps popping up.

2) when I close the document my pc not only asks me whether I want to save the document itself (which I don't always have to do, but sometimes it is useful) but the template as well (even as I made no changes to it). I understand this is triggered because of the links I use. Again, many information is already available on several forums but none of the suggested macros do the trick. How can I make Word to stop this double saving.

What I already tried:

1) but problem is that their is no active template, given that the template opens as a normal document (as it should).

Sub FileExit()
ActiveTemplate.Saved = True
Application.Quit
End Sub

2) but problem is that VBA gives an error code. VBA does not recognise the attached template.

Sub FileExit()
ActiveDocument.AttachedTemplate.Saved = True


ActiveDocument.AttachedTemplate = ""
End Sub


So, my question is: can anyone get me two macro's that can solve my problem?

Thanks a lot in advance. I spent already too many hours on this.

"Template" is a word of art in Microsoft Word. Templates in Microsoft Word

It does not mean a pattern. It means a kind of document that when double-clicked in Windows will create a new document base on the template.

I don't know if that is the meaning you are using.

That said, look into AutoText (Building Blocks). Automated Boilerplate Using Microsoft Word.

You can have a building blocks template that holds the individual user information and another one that holds the information for the office or division, all as AutoText building blocks. You could have a UserForm that gathers the individual information or allows it to be edited. UserForm is another term of art. Create a Simple Userform
Create & Employ a Userform

Your templates then draw on this information with AutoText fields and insert it in the appropriate locations in templates and their resulting documents.

This is a bit complicated to set up, but once done, it works like a charm. I once used it to set up letterhead for an agency with 70 offices and 200 individualized letterheads. (That was in the days of Word 97.)

No macros are required in the document templates but the templates holding the UserForms do, of course, have macros. You can do it without the UserForm and macros but that requires more understanding of AutoText on the part of the people setting up the individual variable files.

I apologize if I missed part of what you wanted. I felt the need to clarify the word "template" before I dug too far into your requirements.

Thanks for your answer. I meant indeed a template as you describe it. I see the advantage of the solution you suggest but without success sofar. Creating the userform works fine, creating the buildingstones as well, but I don't see how to link them. Do you happen to have an example of the letterhead you set up in the past?