ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Standards for a code library (https://www.excelbanter.com/excel-programming/298201-standards-code-library.html)

Tim Zych[_5_]

Standards for a code library
 
Do any developers here use code libraries at work? I am
wondering what successes people have had w/regard to
sharing reusable functions among peers. What fosters the
desire to use the code library and to share/borrow code?
We are adopting the use of SouceBook by FMS and I would
like to know how we can use it successfully in a group
setting.

What should we manage? What should we not manage? How
strict must rules be w/respect to posting a function? Must
we all use the exact same coding style or is there wiggle
room?

steveb[_4_]

Standards for a code library
 
Tim,

I am a moderate at using Excel programming and have found this group to be a
'gold mine' of good code to use.

Over the past several years I have compiled a workbook with bits and pieces
of code for reference and use. Also have another workbook with links to web
sites pointed out in this user group. From the links I have obtained a very
useful add-in for finding answers to my many questions:
www.rondebruin.nl/Google.htm

And whenever I have a serious question - I just ask the group.

As far as style is concerned - there seem to be as many solutions to the
same problem as there are coders. But some code runs more smoothly than
others. The guru's make the best. But most of the code works well.

In a group setting it is helpful that everyone work toward the same style
for the sake of consistancy and ease of working with some one else's code.
Otherwise - what works is what works.

--
steveb
(Remove 'NOSPAM' from email address if replying direct)


"Tim Zych" wrote in message
...
Do any developers here use code libraries at work? I am
wondering what successes people have had w/regard to
sharing reusable functions among peers. What fosters the
desire to use the code library and to share/borrow code?
We are adopting the use of SouceBook by FMS and I would
like to know how we can use it successfully in a group
setting.

What should we manage? What should we not manage? How
strict must rules be w/respect to posting a function? Must
we all use the exact same coding style or is there wiggle
room?




pikus

Standards for a code library
 
Well... Those are all good questions.

What fosters the desire to use the code library and to
share/borrow code?


It depends on who you ask. As far as sharing code goes, if you'r
working with programmers that are programmers because the lov
programming, it's a labor of love and matter of pride and perhap
altruism. If they're in it for the money, it's more likely to be
matter of convenience. Borrowing code is quick, convenient and a grea
way to learn from others.

What should we manage? What should we not manage?
How strict must rules be w/respect to posting a function?
Must we all use the exact same coding style or is there
wiggle room?


You get to make all that up in whatever ways work for you, but i
you're looking for suggestions, find someone that will be using th
library to take responsibility for it, or at least someone that care
about it personally. Someone skilled and organized that will manag
accepting/rejecting submissions and ensuring the code is tidy an
sufficiently documented. You can have as much wiggle room as you wan
for style, but readability and maintainability are of the highes
importance with something like that. - Piku

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com