Using vba to open existing template, close previous (1 Viewer)

Spooky

Registered User.
Local time
Yesterday, 22:46
Joined
Jun 11, 2012
Messages
18
Can anyone point me in the right direction to use a .dot file to open another .dot file and close the first one?
The background is Im trying to work around an existing problem.
In a network situation, I have many users of a single template file (eg TemplateA.dot) and due to the multiple users, this restricts me from editing / changing the file as its locked by users. I also cant change the name of this file as users have a link to it.

My thought is to use a new TemplateA.dot to redirect users (with VBA) to a copy of the actual Template file.

An external config file could then be easily used by TemplateA to control which 'live' copy of the actual template file is accessed by users allowing me to update and maintain an alternate copy without network locking issues.

Current:
User opens TemplateA.dot (network locking problems)

Proposed:
User opens new TemplateA.dot -> activates Copy1.dot or Copy2.dot , Closes TemplateA.dot

Does that make sense?

Question:
How do I open TemplateA.dot, Open Copy.dot and then close TemplateA.dot returning focus to Copy.dot.

Dim objWord
Dim objDoc
Set objWord = CreateObject("Word.Application")
Set objDoc = objWord.Documents.Add("C:\Users\Documents\Copy1.dot")
objWord.Visible = True
objWord.Activate


I have no problems creating config and redirecting to specific copies, its just the opening / closing / focusing of word templates I am unfamiliar with
Or, if you have a better idea then Im all ears!

TIA
 

Ranman256

Well-known member
Local time
Today, 01:46
Joined
Apr 9, 2015
Messages
4,126
Normally, you don't open a template (.dot) to edit...
You use it to open a blank document BASED on the template.
(This stops locking)

Documents.add template
 

Spooky

Registered User.
Local time
Yesterday, 22:46
Joined
Jun 11, 2012
Messages
18
The template itself is a method of creating many different documents, so its a complicated arrangement of user forms. Im frequently upgrading and adding more functionality, hence the need to edit or replace the single live running copy.

So, the end users do kind of open the document based on the template, but the template remains open and locked for about 10 minutes per session whilst that or others are using the userforms (or at least thats what I think is happening)
 

Users who are viewing this thread

Top Bottom