View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
gocush[_29_] gocush[_29_] is offline
external usenet poster
 
Posts: 252
Default separate modules for each sub routine?

The only technical limitation that I am aware of:
the first project I ever wrote I put all code in a single module. At some
point it started crashing. I was advised that problems can occur with very
large modules.

After breaking up the code into logical sections the problem disappeared.
Whether this was due to reducing the module size or perhaps I modified the
code in the process I cant be sure. Just speculation and hearsay.

"smokiibear" wrote:

I'm looking for feedback on whether or not to create separate modules for
each sub-routine and function, or to combine them in them in single modules
(where it makes sense). I realize this may be like asking what is the
"best" flavor of ice cream, but I'm curious to hear what reasons people
have for their preference on this matter.

Thanks for your interest and opinions.

Smokii