Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting code from a macro (by a macro) | Excel Discussion (Misc queries) | |||
Deleting Row Macro | Excel Worksheet Functions | |||
Macro is deleting everything! | Excel Discussion (Misc queries) | |||
deleting row using macro need help | Excel Programming | |||
Deleting macro | Excel Programming |