Copy Normal.dotm file

[macropod]

I'm trying to make an auto Normal.dotm copy file routine when I open a excel file because sometimes i lost my saved macros.

Why would you want to make a copy of Word's Normal.dotm file when you open and Excel workbook? Makes no sense to me.

Moreover, if you aren't making backups using the tools that come with Windows, why not?