Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-02-2013, 02:24 AM
stefaan stefaan is offline Automatic update of links in template - closing attached template without saving Windows 7 64bit Automatic update of links in template - closing attached template without saving Office 2010 64bit
Novice
Automatic update of links in template - closing attached template without saving
 
Join Date: Nov 2013
Posts: 2
stefaan is on a distinguished road
Default Automatic update of links in template - closing attached template without saving

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.
Reply With Quote
  #2  
Old 11-02-2013, 03:30 AM
Charles Kenyon Charles Kenyon is offline Automatic update of links in template - closing attached template without saving Windows 7 64bit Automatic update of links in template - closing attached template without saving Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

"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.
Reply With Quote
  #3  
Old 11-02-2013, 07:46 AM
stefaan stefaan is offline Automatic update of links in template - closing attached template without saving Windows 7 64bit Automatic update of links in template - closing attached template without saving Office 2010 64bit
Novice
Automatic update of links in template - closing attached template without saving
 
Join Date: Nov 2013
Posts: 2
stefaan is on a distinguished road
Default

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?
Reply With Quote
Reply

Tags
auto update, links, template

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic update of links in template - closing attached template without saving Building Blocks not included in Attached Template rphox2003 Word 10 07-29-2012 04:51 AM
Automatic update of links in template - closing attached template without saving Automatic Email Template when Click 'New' eoinymc Outlook 2 06-22-2011 08:31 AM
Update Document Template when Saving the Document File bjbercaw Word 3 11-16-2010 02:03 PM
Automatic update of links in template - closing attached template without saving Automatic Update of links has been disabled: Kal Excel 1 03-21-2010 09:37 AM
Macro to determine attached template zippyaus Word VBA 0 03-02-2010 02:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft