Template with macros won't open as .doc

[Clueless1]

Hello there

I have created a document, which shows the user a window when it opens. The
user chooses options in the window; when the user clicks OK, Word formats the
document according to the user's choices. It all runs fine from the .doc file.

When I save the document as a template, one of two things happens:

1. If the user double-clicks the template from its icon in a folder, it
opens as Document 1.doc, but the window of options does not appear, os the
document cannot be formatted.

2. If the user has Word running and opens the template from File>Open, the
template opens as "Template".dot, and displays the options window.

Is there a way to force Word to open the template as a .doc, (e.g.,
"Document 1".doc), AND show the options window so the user can choose options
and have Word format the document correctly?

Many thanks
Russ

 

[Peter Jamieson]

It sounds as if you have created an AutoOpen macro (or used the equivant
Word document events). If you either rename your routine to be an AutoNew
macro or copy the code you should find that a .dot behaves in a similar way
to a .doc when you double-click one in Windows Explorer or use File|new in
Word. If you use templates properly, the user is unlikely to look for them
using File|Open or from their "Most recently used" file list,

Peter Jamieson

 

[Clueless1]

Thanks Peter

Come to think of it, (and this is very stupid on my part), I don't remember
specifying how the document should open. I don't know how to write an AutoNew
macro, or indeed where I would put it!
I think you have identified the problem; I am just not sure how to implement
the solution.

Best regards
Russ

 

[Doug Robbins - Word MVP]

The change the name of the autoopen() macro that you presently have in the
Template to autonew()

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Peter Jamieson]

Have a look at

http://word.mvps.org/faqs/macrosvba/DocumentEvents.htm

and if necessary

http://word.mvps.org/faqs/macrosvba/PseudoAutoMacros.htm

There may be other articles on that site, and their authors certainly know
more than I do about that stuff.

Peter Jamieson

 

[Clueless1]

Peter, thank you very much indeed. I really appreciate your help.

Best
Russ