VBA to … export VBA modules for archiving or other

Neat. http://www.cpearson.com/Excel/VBE.aspx  Now I can export the modules for text version control  (so we can see the changes). AND use it to standardize all the code between little small projects to ensure that all the good ideas from one period in time can be compared to other projects done in an earlier time.

For instance, lets say we made a great “look for header” routine 4 months ago. Today, the header row is not fixed to row 1 any longer. If we make a new routine that is a little more generic – it needs to have a different name but if we backdate all the other routines, then the idea is better for all projects. The tools in the above link give us all we need to get this completed. … and the code above works – with few changes.