What would keep a Microsoft Word AutoNew() macro from running?

Posted by Chris Nelson on Super User See other posts from Super User or by Chris Nelson
Published on 2009-11-06T21:55:02Z Indexed on 2010/04/03 4:03 UTC
Read the original article Hit count: 475

I'm using Microsoft Office 2003 and creating a bunch of template documents to standardize some tasks.

I know it's standard practice to put the templates in an certain place Office expects to find them but that won't work for me. What I want is to have "My Template Foo.dot" and "My Template Bar.dot", etc. in the "My Foo Bar Stuff" on a shared drive and users will double click on the template to create a new Foo or Bar.

What's I'd really like is for the user to double click on the Foo template and be prompted for a couple of items related to their task (e.g., a project number) and have a script in the template change the name that Save will default to something like "Foo for Project 1234.doc".

I asked on Google Groups and got an answer that worked....for a while. Then my AutoNew macro stopped kicking in when I created a new document by double clicking on the template. I have no idea why or how to debug it.

I'm a software engineering with 25+ years of experience but a complete Office automation noob. Specific solutions and pointers to "this is how to automate Word" FAQs are welcome. Thanks.

© Super User or respective owner

Related posts about microsoft-word

Related posts about microsoft-word-vba