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
|