PC Review


Reply
Thread Tools Rate Thread

Automatically save document when closing

 
 
=?Utf-8?B?Q2xhbmc=?=
Guest
Posts: n/a
 
      7th Mar 2006
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.
 
Reply With Quote
 
 
 
 
Charles Kenyon
Guest
Posts: n/a
 
      7th Mar 2006
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/...SaveAsPath.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/...tSavePrint.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

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
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.


"Clang" <(E-Mail Removed)> wrote in message
news:9D444C4A-F0A0-4A0E-88ED-(E-Mail Removed)...
> 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.



 
Reply With Quote
 
=?Utf-8?B?RmFzdFdvcmRIZWxw?=
Guest
Posts: n/a
 
      8th Mar 2006
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

"Clang" wrote:

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

 
Reply With Quote
 
=?Utf-8?B?Q2xhbmc=?=
Guest
Posts: n/a
 
      8th Mar 2006
John,
Thank you for your help, your answer along with the Charles' answer solved
most of my problem.

Thanks again.

"FastWordHelp" wrote:

> 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
>
> "Clang" wrote:
>
> > 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.

 
Reply With Quote
 
=?Utf-8?B?Q2xhbmc=?=
Guest
Posts: n/a
 
      8th Mar 2006
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.

"Charles Kenyon" wrote:

> 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/...SaveAsPath.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/...tSavePrint.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
>
> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> --------- --------- --------- --------- --------- ---------
> 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.
>
>
> "Clang" <(E-Mail Removed)> wrote in message
> news:9D444C4A-F0A0-4A0E-88ED-(E-Mail Removed)...
> > 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.

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DON'T ask if I want to save when closing a document =?Utf-8?B?U2ln?= Microsoft Word Document Management 8 13th Aug 2009 04:50 PM
Run macro automatically upon opening or closing document Munchkin Microsoft Excel Programming 1 8th Jun 2009 03:27 PM
Styles change automatically after closing the document B Microsoft Word Document Management 7 20th Dec 2007 10:49 AM
Word does not automatically ask to save file before closing, why? =?Utf-8?B?UmFuZGFsIEQ=?= Microsoft Word Document Management 2 6th Jan 2006 01:13 AM
Frontpage does not automatically save embedded files when closing =?Utf-8?B?Q2hvcHBlciBEYW4=?= Microsoft Frontpage 9 18th Feb 2005 12:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:25 PM.