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" <(E-Mail Removed)> wrote in message
news:79e98846-a18f-480e-af3f-(E-Mail Removed)...
> 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