Backup of template with macros

[Saabeirik]

Hi!

I've made a word template with some macros (userform), and I want to make sure that I've backed up everything right. (So that I don't lose anything if my computer where to crash) I've read about people taking backup of macro directory etc, but maybe this is only necessary for regular documents?

It seems that the macros is stored with my template, so that if I keep a backup of this I'm safe?

Can anyone confirm this? :-)

[fumei]

Sure. If you make a backup of the .dot file, then...there is a backup.

Obviously if you have multiple files in a template folder, then you should backup the whole directory. Backups are good! Multiple backups are better.

[Frosty]

You can also export your code modules (which, except for the non-code part of a UserForm, are simply text files). This is also a way of getting rid of inevitable "template bloat" when you're developing a macro template.

[fumei]

Agreed. In fact, if you are developing complex code this should be standard procedure. It keeps your module(s) as clean as possible.

Post #6,000!