View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pete pete is offline
external usenet poster
 
Posts: 88
Default VBA deleting Macro

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