Hi, By now I have hundreds upon hundreds of vb and VBA subs and functions scattered through dozens of .mdb, .xls, .doc, vbp and other files. I find I'm loosing track of many of them -- especially those that were brief fixes to a minor problem. I wonder if anyone has thoughts on how to maintain a record of functions created, or maybe a handy way to file them...
any thoughts?
Keith
Sat, 14 May 2005 21:35:08 GMT
Nathan Carrol #2 / 3
Keeping track of all those functions!?!?!
if you had developer addition it has something called code librarian. also what about making a table with a memo field for the code, a subject field etc.
Quote:
> Hi, > By now I have hundreds upon hundreds of vb and vba subs and functions > scattered through dozens of .mdb, .xls, .doc, vbp and other files. I find > I'm loosing track of many of them -- especially those that were brief fixes > to a minor problem. I wonder if anyone has thoughts on how to maintain a > record of functions created, or maybe a handy way to file them...
> any thoughts?
> Keith
Sat, 14 May 2005 23:18:57 GMT
keit #3 / 3
Keeping track of all those functions!?!?!
Hi Nathan,
Thanks for your ideas...
Keith
Quote:
> if you had developer addition it has something called code librarian. also > what about making a table with a memo field for the code, a subject field > etc.
> > Hi, > > By now I have hundreds upon hundreds of vb and vba subs and functions > > scattered through dozens of .mdb, .xls, .doc, vbp and other files. I > find > > I'm loosing track of many of them -- especially those that were brief > fixes > > to a minor problem. I wonder if anyone has thoughts on how to maintain a > > record of functions created, or maybe a handy way to file them...
Keeping track of all those functions!?!?!