VBA deleting Macro

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Does anyone know how to cycle throught a folder of excel
docs and delete all the VBA accociated with saved files?

I have a massive folder of excel docs that is causing way
too much resource usage on my computer and I knopw in
each one of the file there is VBA that can be deleted,
because it is nolonger needed for the saved document. I
would put this deleting macro in the main spreadsheet
that creates all other files so it will not be deleted
when the macro is initiated.

Any ideas?
Thanks
Pete W
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to recover deleted macros 0
Excel 2003 - VBA to get a list of Module names in the project 4
Macro that will insert a simple text string in top cell of text file 1
Excel VBA in Citrix. 0
Run macro on all files in a specific folder 3
Delete some letters 3
using excel vba ope a word doc and copy-paste into another word doc 0
Deleting a row where characters 34, 35, 36 are 000 1

Back
Top