What method do you use to save/store your developed code?

[Guest]

In the past year or so my Excel knowledge, and usage has grown a great deal.
Much from what I have learned on these boards.

I am constantly refering to code or function examples I have used in past
projects. My process today is getting hard to manage because it is difficult
to always remember which workbook a particular piece of code is in. My
thought was to develop a storage method to keep and later search and reuse
what I have deveoped.

One idea I have is to use MS Outlook journal entries to keep the examples.
This has built in search, ability to categorize, etc.

What methods are you using?

Thanks,

 

[Paul B]

Scott, I keep code examples in word with a description of the code at the
top and link it to the code using a bookmark
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Place your code into individual stand alone modules. Give the modules a
descriptive name such as modFileSystemObjects and then export the module.
When you need to work with files, just import the module and you are off and
running. This way your projects will go together like Lego.

 

[Guest]

Thanks Jill!

 

[Guest]

Thanks Paul!

 

[Guest]

That's a great idea!

Place your code into individual stand alone modules. Give the modules a
descriptive name such as modFileSystemObjects and then export the module.
When you need to work with files, just import the module and you are off and
running. This way your projects will go together like Lego.