Changing path for template

  • Thread starter Thread starter TM
  • Start date Start date
T

TM

Okay, I am opening word using automation (from Access).
I have it set to come up automatically to a "sop"
directory when the document is originally created,
however, when a person edits the document I need two
things to take place, I need the previous doc (the one
originally opened) to be saved to a backup directory and
then I need them to be prompted to save the new edited
doc to a "drafts" directory. I cannot seem to get it to
change, word just overwrites the previous file. Also,
another thing I am having problems with is that it's set
to automatically go to the "sop" directory, but it seems
I have set the default directory to that path but I only
want it to be that case when using these two specific
templates. I will also post this to the VBA group.
Thanks for any suggestions though!
 
It sounds like the "document that is originally opened" is the template.
Your code should not be opening the template. It should be using

Documents.Add "TemplateName"

Then all your code has to do is save the new document.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
 
Back
Top