Delete Code from ThisWorkbook (without opening)

[Papi]

I have almost 600 files in one directory and need to remove all the VBA code from "ThisWorkBook" from Y:\Work Order\Filename.xls If possible I would like to save a few hours of time. Any help would be great.

Thanks

 

[John Davis]

I have almost 600 files in one directory and need to remove all the VBA code from "ThisWorkBook" from Y:\Work Order\Filename.xls If possible I would like to save a few hours of time. Any help would be great.

Thanks

Maybe something here can help.

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

 

[Papi]

Thanks John.

I'll have to read through that tonight when work matters are not on my back.

Alan