i have 3 modules. module1 opens a application file, module2 saves the
file using (Ctrl+Shift+R), and module3 closes the opened application.
what i am tring to do is remove the macros from the document when i
save it? where do i put the macro that deletes the macros and what dose
the macro look like??

You should find some information on this at Chip Pearson's site

http://www.cpearson.com/excel/vbe.htm

Changes made in a workbook by a macro, such as deleting code, do not take
effect until the macro ends. So You might have to use a second, possibly a
temporary workbook (create it, put a macro in it, then use Ontime to call
that macro) to delete the macros and then save the original workbook.

http://www.cpearson.com/excel/ontime.htm

another approach might just be to copy information to a new workbook and not
copy macros. A lot depends exactly what you are doing.

--
Regards,
Tom Ogilvy

"toolroomman" wrote in message
oups.com...
i have 3 modules. module1 opens a application file, module2 saves the
file using (Ctrl+Shift+R), and module3 closes the opened application.
what i am tring to do is remove the macros from the document when i
save it? where do i put the macro that deletes the macros and what dose
the macro look like??

hi,
see this site
http://www.cpearson.com/excel/vbe.htm

Regards
FSt1

"toolroomman" wrote:

i have 3 modules. module1 opens a application file, module2 saves the
file using (Ctrl+Shift+R), and module3 closes the opened application.
what i am tring to do is remove the macros from the document when i
save it? where do i put the macro that deletes the macros and what dose
the macro look like??