Ok heres what I,ve got.
I have a document (*.doc) which I use as a template. The document is used to generate invoices. So when I open the document it automatically asks me do I want to Update the fields as I have a marco for the AutoOpen. I fill out the fields as I have 'ASK' fields and the fields are all updated, price, date, invoice total etc. Then when I close the doc it uses the AutoClose to save the doc as Invoice + Date... eg Invoice 20080126.
Ok now the issue. When I send the Invoice20080126 to someone and they open it the marcos get fired again and I dont want them to. They seem to get copied to the new document. I have tried saving the orginal template.doc as a .DOT (template) and creating a document based on it. I changed the autoopen macro to only get fired on a new event and thought this would work but it does.
So how do I open my template and create a doc without copying over the macros so I can send it to another user and they can open it without any macros getting fired of, when they open or close the document.
PS... anyone know of any good sites that explain the proper use of templates in Word. I,m fairly decent on the VBA but never really got my head on what happens with these templates
best regards Mick