Save Excel file without Macrs!!
 

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??

Save Excel file without Macrs!!
 

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??

Save Excel file without Macrs!!
 

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??