Code Library Organizer - What do you use?

[tweedle]

So over time one accumulates a lot of little code snippets, and some very specialized ones to archive and pull out when needed.

What does anyone here use to keep code modules organized?
Right now I'm using TextPad Workspaces to group common themes and templates together; wondering if there is a better way.
Seems there should be.

My Apologies if this should have been in the General Excel forum, my decision matrix is in the shop.

 

[BrianB]

I have hundreds of code snippets. I did try the textpad method and even MS Access but it was never satisfactory from the need to copy/paste code to the "store" and then back to a module each time.

I therefore use normal workbooks in a single XL_MACROS folder. I have a handful of sub folders where Excel is combined with other applications like Word/Access/ or Internet Explorer. Some workbooks may contain a single macro, others contain several macros on a single subject (eg. file handling). The big benefit here is that a file can be opened and the macro run immediately.

It is possible to search for words contained in files, but I rarely need to use this. I always put comments in my code, including a heading to say what the code does.

I will also reveal my other secret/non-secret store. Because the same basic problems keep arising I store code in places like this, for which I have an index listing in a single text file
http://www.mrexcel.com/board2/viewtopic.php?t=277766

 

[BrianB]

PS. We can have a URL in TextPad and right click it to open the web page.

 

[tweedle]

Thanks for the reply Brian - interesting personal use of 'the cloud'.