I'd not recommend doing that. As there are several issues associated.

Have a read of link.
http://www.cpearson.com/Excel/VBE.aspx

I'd recommend, including check to disable macro based on workbook name (or some other check), have it in the existing workbook and SaveCopyAs.