macro template problem

Hello,

I am looking for an answer a macro question as follows. I searched from internet but could not find an answer and there for I am asking.

We have quite large company which has several sub companies. Each company is concentrated on its own business and IT solutions are bought from outside. However this problem is so common that it takes too much time ask help from outside, every time it occurs, so I am looking for another solution.

Company has multiple word documents in use which are using macros. Macros cannot be integrated to documents itself so macros needs to be run from separate location. Old macros are driven from Word startup folder’s roaming section. I know it is possible to create new location for macro template and ask Word to point in it. However it seems that macro templates which are located some other folder than in startup will not stay checked. Is there any way get around of a problem?

It would be best if there could be two separate locations where Word could run macros and both would stay checked as default.

Our company is using Office Word 2010 and Windows 7.

Kind regards,

Joonas-Matti Tuominen

There are two options, neither of which entirely fits your requirements.


1. Set the Word Startup folder for all the users to a common location, set that folder as a trusted folder and put your global templates there.

2. Leave the Word Startup folder where it is and provide each user with a macro for their normal template to check (and if necessary add) the added, but unchecked templates from their central location when Word is started e.g. as follows


Sub AutoExec()
Dim oTemplate As AddIn
Dim bTemplate As Boolean
Const strAddInPath As String = "C:\Path\" 'The common add-in template location

    'repeat for each add-in
    bTemplate = False
    For Each oTemplate In Application.AddIns
        If oTemplate.name = "Add-in Name.dotm" Then
            AddIns(strAddInPath & oTemplate.name).Installed = True
            bTemplate = True
            Exit For
        End If
    Next oTemplate
    If Not bTemplate Then
        AddIns.Add Filename:=strAddInPath & "Add-in Name.dotm", Install:=True
    End If
    'end of repeat


End Sub

Graham Mayor (Microsoft Word MVP 2002-2019)
For more Word tips and downloads visit my web site
https://www.gmayor.com/Word_pages.htm

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thank you for the quick response.

I will check out if either of your solutions could help me, though as you said they do not fill entirely my requirements. But thank you any way. 

- Joonas-Matti

Kind regards,
Joonas-Matti Tuominen
Tampere, Finland

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

A large organization which I worked with earlier this year pushes (via a login script) any global template updates to each user's startup folders each time they log into their work station. 

Greg Maxey
***
Death smiles at us all, but all a man can do is smile back.


For more help with Word visit:
http://gregmaxey.com/word_tips.html

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Is there a reason you are not using macros in 'attached templates'? 

You can add a shortcut in the startup directory that points to a template stored elsewhere. This would give you a template checked as default but actually installed somewhere other than the startup folder.

Andrew Lockton
Melbourne Australia

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Okay thank you, I will look into these solutions. 

Yes there is reason why we cannot use macros integrated to Word documents. We are using third party software for resource planning & management and that does not understand Word documents which include macros. So it has to be done by macro templates. 

I think "login script" might be best option for our purposes. Is that DOS batch file, which just copies files from network location and replaces old ones in Word's startup folder? Simple solutions are usually best ones. 

Kind regards,
Joonas-Matti Tuominen
Tampere, Finland

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I wish I could tell you for certain that it was simple and just a DOS batch file, but I really don't know anything about login scripts (what they are or how difficult too implement).  I can say that the IT types I worked with made it sound very simple.

Greg Maxey
***
Death smiles at us all, but all a man can do is smile back.


For more help with Word visit:
http://gregmaxey.com/word_tips.html

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 14, 2025 Views 92 Applies to: