code to delete module / macro in another file
 

Is it possible to write code to delete a module or macro in another excel file.

I have a file that I savecopyas but need to remove the modules and macros
from the copy file only.

code to delete module / macro in another file
 

hi
yes it is possible. see this site....
http://cpearson.com/excel/vbe.aspx
make note of the warning.

Regards
FSt1

"Ray Clark" wrote:

Is it possible to write code to delete a module or macro in another excel file.

I have a file that I savecopyas but need to remove the modules and macros
from the copy file only.