Declaring variables in Module vs. Public
There is a difference, because the variables will be in scope for the whole
project, but in reality you probably won't notice it. There is a bigger
question over design, structure, etc., but by going to multiple modules you
are starting to think along the right lines.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Jeff" wrote in message
...
Hi,
I have written code and there are a number of variables that are declared
at
the top of the module - so they can be used by all subs in the module.
I am expanding the code and am considering separating the new added code
into a different module because it would be organized a little better.
My question is - is there a performance difference to declaring the
variables public rather then "Module" wide. Any advice under what
circumstances to break code into different modules and when to declare
public
vs module wide.
I have 1 module now, but I could break up the code into 6 modules that
have
product specific data. All the variables would have to change to public
because they are common in the 6 modules.
Thanks for your help
|