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

Chopper50

New Member
Joined
Mar 14, 2013
Messages
30
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.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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.
 
Upvote 0
I am saving it as a .xls, but it still keeps the code with it. Will the .xlsx save it without the code?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,024
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top