Lew, if you just want to back them up in case of loss you just need to back
up the files they reside in. Most Word macros get stored in Normal.dot which
you should find at C:\Program Files\Microsoft Office\Templates, but there
could be others. Normal.dot contains lots of other personal settings and
should always be backed up.
Excel macros are either in individual workbooks or in Personal.xls, normally
at C:\Program Files\Microsoft Office\Office\XLStart - you have to specify
when you're creating the macro.
If you want to save them for inclusion into other documents, then I think
you'll have to export them.
> -----Original Message-----
> Does anyone know how to backup Word and Excel macro's?
>
> Seems like the only way to do it is to open Visual Basic Editor and
> export the file to a floppy.
>
> Lew Russakov
The NOSPIN Group Promotions is now offering
special "Free-After-Rebate" Software specials in conjunction
with Beyond.com. We have new offers all the time!!!
http://nospin.com/promotions
|