Automatically save document when closing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to configure a template so that when it is opened as a
document it will automatically save as a .doc to a specified location when
you close out of the document? I would want this to do this without further
input from the individual using the template.
 
First, you don't open a template to use it, you create a new document based
on the template. This may seem picky, but it is an important distinction.

Second, the default location will start as the Word documents folder
location. Once a document is opened or saved from within Word, that folder
becomes the new default location.

Third, you can set the save directory as part of an AutoNew procedure in
your template. http://word.mvps.org/FAQs/MacrosVBA/ChangeSaveAsPath.htm
However, if the user opens or saves a document after that, it will switch
around, so...

Fourth, you can setup a substitute SaveAs command.
http://word.mvps.org/FAQs/MacrosVBA/InterceptSavePrint.htm. Good luck.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide


--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 
Hi Clang,

This can be done using VBA. You could provide a document that your user
opens up, works with, and then closes. The VBA could trigger on close and
look for the predefined folder hard coded into the VBA and even create the
folder if it's not available on their system. You would have to define how
you want to name the file and what to do if that filename already exists. It
could easily add a date or -02 suffix to the name to deal with this.

--John
www.FastWordHelp.com
 
John,
Thank you for your help, your answer along with the Charles' answer solved
most of my problem.

Thanks again.
 
I know I am creating a new document when I use a template; however, I work
with people who only use the very basics of the program. If I tell them they
have to create something instead of opening the template they get frazzled
and think they have to do a lot more than they actual have to do. So I have
gotten used to saying open a template.

Anyway, your instructions helped immensely. I have created the macro that
automatically goes to "SaveAs". Now I just need to figure out how to
deactive the "Cancel" button.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top