Keeping track of code

This isn't a programming question, but it's something I've been thinking
about lately:

How does everybody keep track of subs/functions/applications they've written?

Sometimes I find myself needing a solution to a problem I *know* I've solved
before, but then I can't find it. So I have to look through everything,
search online for the solution, etc. Frustrating... and not terribly
efficient.

For me - I have a special workbook.
Each sheet has a catagory name and any code for that catagory is put on that
sheet.
I use a (moving) Index sheet to list all the sheet names and use it to
navigate between
sheets. I also include links to web sites.

My workbook now has about 100 worksheets and continues to grow.

--
steveB

Remove "AYN" from email to respond
"Eric White" <EricWhite@discussions.microsoft.com> wrote in message
news:D31B9D9C-61D7-4416-ABF8-2A3DE05783FF@microsoft.com...
> This isn't a programming question, but it's something I've been thinking
> about lately:
>
> How does everybody keep track of subs/functions/applications they've
> written?
>
> Sometimes I find myself needing a solution to a problem I *know* I've
> solved
> before, but then I can't find it. So I have to look through everything,
> search online for the solution, etc. Frustrating... and not terribly
> efficient.

Eric,

(1) I use a variation of Chip Pearson's code for exporting modules for
each workbook that I create that contains code (each workbook having
its own subdirectory for the modules). Then, I use Start>Find>Files or
Folders to search for keywords ("containing text").

http://www.cpearson.com/excel/vbe.htm
Exporting All Modules In A Project

(2) I also have a workbook that contains a worksheet with an
alphabetical index listing various issues that I have researched. This
sheet contains hyperlinks to text files that contain code snippets or
hyperlinks to Internet sources (Google, WebSites, etc.). I then search
by keyword and fill a ListBox; selecting an item in the ListBox brings
me to the appropriate hyperlinks.

Any time that I encounter a subject that may prove useful in the
future, I store that information for later perusal.

Not 100% foolproof, but I rarely spend excessive time re-researching
topics that I've seen before.

Paul

----------------------------------------------------------------------------------------------------------------------

>How does everybody keep track of subs/functions/applications they've written?

Great question.

Many times my prior "solutions" would be better off scrapped, my learning
curve has been so steep the past couple years. I just look at my old
solutions and say "what was I THINKING?!" I look forward to the day when my
own re-usable code is worth re-using.


<pfsardella@yahoo.com.nospam> wrote in message
news:ra9fa1hm2j5bcgms6nlhnjl7th5kalvkaj@4ax.com...
> Eric,
>
> (1) I use a variation of Chip Pearson's code for exporting modules for
> each workbook that I create that contains code (each workbook having
> its own subdirectory for the modules). Then, I use Start>Find>Files or
> Folders to search for keywords ("containing text").
>
> http://www.cpearson.com/excel/vbe.htm
> Exporting All Modules In A Project
>
> (2) I also have a workbook that contains a worksheet with an
> alphabetical index listing various issues that I have researched. This
> sheet contains hyperlinks to text files that contain code snippets or
> hyperlinks to Internet sources (Google, WebSites, etc.). I then search
> by keyword and fill a ListBox; selecting an item in the ListBox brings
> me to the appropriate hyperlinks.
>
> Any time that I encounter a subject that may prove useful in the
> future, I store that information for later perusal.
>
> Not 100% foolproof, but I rarely spend excessive time re-researching
> topics that I've seen before.
>
> Paul
>
> ----------------------------------------------------------------------------------------------------------------------
>
>>How does everybody keep track of subs/functions/applications they've
>>written?
>

Maybe a freeware program like TreePad Lite could be a good solution.

RBS