Force save when using File New

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ricki Miles - 28 Jul 2005 23:35 GMT

I am creating a template in Word 2003. When the template is used by
choosing File, New, I would like the Save As dialog box to come up
automatically to force the user to save it in a folder and with a filename
of their choice. I can record the macro and save it as AutoNew, but I can't
close the dialog box during the recording.

Thanks,

Ricki

Reply to this Message

Jezebel - 29 Jul 2005 00:06 GMT

You can't create good macros by recording. Recording is useful to give you
an idea of how to do something, and as a shortcut for repetitive keystrokes.
But to create useful macros you need to write your own code. In this case,
add this line to your AutoNew macro --

Dialogs(wdDialogFileSaveAs).Show

This doesn't quite 'force' the user to save the document: they can still
cancel the dialog. You can check for this if you need to. Read Help on the
Dialogs object and see the examples on using the return value.

>I am creating a template in Word 2003. When the template is used by
> choosing File, New, I would like the Save As dialog box to come up
[quoted text clipped - 6 lines]
>
> Ricki

Reply to this Message

Ricki Miles - 29 Jul 2005 00:31 GMT

Thanks very much,

Ricki

> You can't create good macros by recording. Recording is useful to give you
> an idea of how to do something, and as a shortcut for repetitive keystrokes.
[quoted text clipped - 17 lines]
> >
> > Ricki

Reply to this Message