AutoOpen Command - Big problem

[wordperfectconvert]

I use a case management program that assembles data to be placed in documents. I have created a number of templates to use with the program. When the case management program opens the documents, the AutoOpen macro commands don't work. I am at a total loss on how to make the macros run when the template is opened.

I attempted to duplicate the opening process so that the AutoOpen macros would not run. The only way I could duplicate the opening of a template where the autoopen macro would not run is by double-clicking on the template from the Windows Explorer window.

I have contacted the software developer to get them to change the way a template is opened, but they will not change. Can anyone help me find another way to make by macros open automatically. Thank you.

Bill

 

[RoyVidar]

I think the AutoOpen runs when opening an existing document, try using the AutoNew, which I think works on new documents based on the template.

Roy-Vidar

 

[TonyJollans]

Hi Bill,

A couple of questions if I may.

Are you (or your case management tool) trying to create a new document based on a template or open an existing document?
Do you know how (i.e. with what code) your case management software invokes Word and/or opens your document?
Where do you have your AutoOpen Macro?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[wordperfectconvert]

Roy-Vidar,
Thank you. The AutoNew worked perfectly. Problem solved.

Tony,
Thanks for response. That is part of the problem. I don't know exactly how the case management program is opening the template, but Roy-Vidar's suggestion of AutoNew worked fine.

Bill