save file wihout vba macros

[hals_left]

When I create a new file from a template and save it as a document,
(.doc) and then close & re-open it, word still warns me that the .dot
file contains macros. And Project explorer shows all the elements in
the .dot file that creatd it.

How can i save the document created without the vba,macros and
userforms?

thanks
hals_left

 

[Peter Aitken]

When I create a new file from a template and save it as a document,
(.doc) and then close & re-open it, word still warns me that the .dot
file contains macros. And Project explorer shows all the elements in
the .dot file that creatd it.

How can i save the document created without the vba,macros and
userforms?

thanks
hals_left

That's what templates are for. There's no point in creating a doc from a
template if you do not want the tenplate's elements in the doc. You can
delete all the VBA stuff before saving the doc but it would be easier to
create a template that contains only what you want in the document.

 

[hals_left]

The VBA and Userform elements in the template are soley to populate
the doc with data from a database. Normally users would just print and
sent it by post. Now they want to email it - is there no way of saving
the finshed document without the vba code and userform ?

Is there another way to achieve this?

thanks.

 

[RBM]

Conceptually, you could put all the required code in a global template
that is loaded on startup. It would then be there and available for
use when the document is created but not actually saved with the
document when it's saved.

 

[hals_left]

Thanks, I will take a look at global templates.

 

[Charles Kenyon]

Save your templates in a regular templates folder. For more on the different
kinds of templates, tabs on the file new dialog, and locations of templates
folders see http://addbalance.com/usersguide/templates.htm. Then set your
macro security to trust installed templates and add-ins.

 

[hals_left]

Charles, that stops the macro warnings, thanks. But the docs created
and saved still contain the vba and form.

 

[hals_left]

Charles, that stops the macro warning, thanks. But the docs created and
saved still contain the templates vba and useforms.

 

[CarolineJ]

The docs created from the template only look like they have the code - but
the code is actually in the document template. If the template was removed
from the PC or the doc is opened on another PC without the template being
available the code would not be there. Also if the document is no longer
'attached' to the template the code will go.
To check you can try Tools, Templates and Addins from the menu, remove the
name of the template from the 'Document Template' box make sure
'Automatically update document styles' is not selected then click on OK.
This attaches the doc to Normal.dot and uses that as the document template.
Now if you check, the code will not be visible - unless of course it also
exists in your normal.dot (but it wouldn't if you emailed it to someone
without the template on the desktop either as the code is not in the doc but
in the tempalte).

Hope that helps and does not confuse

Caroline