Previously, a post answered the question of how to run code that would
delete embedded code in an application:
www.cpearson.com/excel/vbe.htm

However, as far as I can tell this is run within the IDE environment.

Is there a way to accomplish the same result using VBA alone? (I'm
running excel 2003 on windows XP)

My need: After the user inputs data into a template and the data is
reduced, I want to strip out the code, instructions, userforms, etc
before the template is saved under a new file name.

I currently get rid of everything but the VBA modules and userforms,
which add about 800K to each file.

Art