macro to export all the modules at once

[neveu]

hello forum,

i would like to save all the modules that contains VBA code from an excel file.

does any one has any idea how to do that?
is that possible with a macro?

best regards,
Valentin

 

[jeffreybrown]

Try...

http://www.appspro.com/Utilities/CodeCleaner.htm

 

[wigi]

Take the first code mentioned here (on top of the screen):

http://www.snb-vba.eu/VBA_Excel_VBproject.html#L22

It's good and interesting code from a fellow Excel VBA colleague of mine in the Netherlands.