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

VBA deleting Macro
 

Look at Chip Pearson's page on programming the VBE

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy


"Pete" wrote in message
...
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