Results 1 to 11 of 11
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts

    Office 2003 templates not working properly in Office 2010

    Hi
    Has anyone had problems using templates, originally created in MSO 97, with MSO 2010.
    The templates are used as merge documents, merge information from our SQL CRM. Worked fine under 2003 but now take upto 40 mins to generate new documents and crashing if the computer is tasked with doing anything else.
    cheers

    Phil Carter

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts
    I haven't had problems with old templates so I don't think your experience is the norm.

    Whenever 'slow to open' is a problem I think of the 'attached template' being the problem - Are you sure the templates are actually templates and not simply named as dot files? If they are true templates then you won't be able to attach a template to them.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Andrew
    I am of the same opiion as you. However, the staff who are having(caused) the problem insist that they used the template to create the letters concerned.
    The problem manifests itself as follows:
    1 Staff wish to view a previousely created letter.
    2 Navigate in the client database to the letter
    3 Click to view or edit
    4 Server attempts to open letter but finds it has an template attached
    5 Server trys to locate template on previous server (CRM and all associated files have been transferred to a new server)
    6 Server searches but to no avail and eventually (up to 20mins) opens the document
    cheers

    Phil Carter

  4. #4
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts
    Sounds about right...

    Put a template with the same name as the attached template into the user's 'User Templates' or 'Workgroup Templates' location. Does that speed things up?
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  5. #5
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    I believe that would work fine. However, the problem we have opening old fiuled letters, etc. that have retained the link to the template, and as such, the old server.
    It has been noticed that only a few documents, when opened, have a dialogue pop up to state "searching for the document on \\server\folder\folder\document".
    What we are after is a methodology to prevent this from happening in the future (deleting the link to the template on creation).
    cheers

    Phil Carter

  6. #6
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts
    If you want a future methodology such as removing the link then you could add a macro such as the following to your Normal template
    Sub AutoNew()
    ActiveDocument.AttachedTemplate = ""
    End Sub

    This won't help your existing problem though.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  7. #7
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Thanks Andrew
    I think a major re-education of how to use Word templates needs to be undertaken. Failing that I'll get a bigger hammer!
    cheers

    Phil Carter

  8. #8
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Andrew
    Your suggestion didn't appear to work with AutoNew or AutoOpen yet when I reopened the normal.dotm I get a "Runtime 4198" command failed error
    cheers

    Phil Carter

  9. #9
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts
    Yeah, AutoOpen is not a great idea to test. The code will fail when you open a TEMPLATE since templates can't be attached to templates.

    AutoNew is far less likely to be triggered on a template itself.

    Getting back to your original and existing problem - did the proposed solution of placing a template with the same name into the User Templates location not work? Why are we even investigating any other options?
    Last edited by Andrew Lockton; 2013-02-13 at 21:00.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  10. The Following User Says Thank You to Andrew Lockton For This Useful Post:

    bonriki (2013-02-17)

  11. #10
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Andrew
    The problem with loading the template into the users template directory is that the template is a global template, one many thar staff use regularly. I am loathe to load on local folders as updates become a nightmare!

    I have created a work around as follows;
    - Created a macro using your code
    - Instructed users that when they find a template is trying to locate temlpate on another server press Esc. This tops the operation and loads the file.
    - Run the newly ceated macro stripping out all the links.
    - Save original

    Works a treat.

    We have many tempates that have been created over the years but the problem only manifests itself with some.

    Thanks for your help
    cheers

    Phil Carter

  12. #11
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts
    I'm glad you got a solution that works.

    Since you are using Workgroup templates then you should also be able to put a template with the same name in the global template directory to get the same effect.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •