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.
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
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