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

Code that deletes code is regularly seen as a virus by anti virus programs.
If this app is used by other people, the workbook may end up being
quarantined and not easily retrievable.

A better approach to doing what you want is to create a code workbook which
works with a template which has no code.

--
Regards,
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility

http://www.higherdata.com/sql/batchsqlfromexcel.html
Create batch SQL from Excel

"c1802362" wrote in message
...
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

thanks for the heads up - I hadn't considered the anti-virus issue

Art