We have a Word application that we disperse to the field. It has a VBA wizard in it, triggered by autorun. When you open the Word document, you are asked if you want to enable or disable macros. (We want to sign the document and tell the field to set us as a trusted source, but we haven't gotten that far, yet).

The VBA code is basicly a wizard. Before the wizard, we had 10 sperate Word form documents that we sent to the field. They would have to select the correct document and fill out the correct form fields with the correct information. The wizard now prompts them, figuring out which form they need to fill out and generating it for them, with all the data filled out.

One of the features of the wizard is templates. If you find your self filling out several of these forms for the same address, you can create a location template. Next time you need to fill out an address, select this template, and it will fill all the address fields for you.

The template data is saved in document variables, and are unique to the copy of the document you have. Well, as we release new versions of the Word document with new versions of the VBA wizard, the users in the field have to recreate their templates.

I had an idea, we could just open their old file, copy over all the document variables, and viola.... Using code in the newest version, I prompt them to open the old version they still have. I thought it was a good idea, but I can't avoid the Autorun trigger. So the code in the new wizard pauses as the old wizard launches.

Any ideas? Did I just confuse everyone? Do I need to create an example?