Word templates and VBA macros

By byron.l.coulter ·
Reason for the question:
I am attempting to build a small application for our business group. It will be driven by a Word document containing several form fields. These form fields will contain data emailed from our clients to our office. I have created a document containing these form fields, and with an imbedded VBA macro in it. The form, when received, will be reviewed by someone in the group. That person will then press a shortcut key combination, and the macro will then transfer data from the form to an Access database I have created. That part has been tested and works.

There is, however, a concern about the macro being imbedded in a form that will be placed on a corporate Sharepoint server and used by hundreds of clients all over the world. My manager wants to create a template document that does not contain the macro in it, just the form fields. This template document will be placed on the Sharepoint server. Another template, this one containing the macro, will be created on my business group?s server.

My question:
Is it possible for the first document (the one with the form fields) to work in conjunction with the second form (the one with the macro) to get the same effect as my single document with form fields and the macro? I know that templates and .dot files affect the creation and use of new documents, but do they have any effect on a previously created document? Does Word even consider a template document when it is loading a previously created document to display?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums