Delete all VB Code from an open Workbook with VB code from a different open Workbook Excel 2007

[Chopper50]

I have an Excel Template that has a lot of VB code tied into it. Daily the workbook generated from the Template gets saved to a folder. I would like to write a VB code in another workbook that will open all of the daily workbooks and delete the VB code that is in it. I have the code to open all of the workbooks, however I'm not sure how to delete the VB Code that is tied to it.

I'm looking for VB Code to delete VB Code in another workbook.

 

[JoeMo]

If you are using Excel 2007 or a later version, have you considered saving the daily template with a .xlsx extension instead of .xlsm. That will automatically remove all VB code upon SaveAs.

 

[Chopper50]

I am saving it as a .xls, but it still keeps the code with it. Will the .xlsx save it without the code?

 

[JoeMo]

i am saving it as a .xls, but it still keeps the code with it. Will the .xlsx save it without the code?

Yes, after you save it/close it/and re-open the code will be deleted.

 

[Chopper50]

Should have just tried it. It did work. Thanks for your help..

 

[JoeMo]

Should have just tried it. It did work. Thanks for your help..

You are welcome. Thanks for the feedback.