keyongtech


  keyongtech > excel.* > excel.programming > 12/2005

 #1  
12-15-05, 10:28 PM
justaguyfromky
I would like to give a name to all of my modules because I have over 60 of
them and it is starting to get confusing finding the one I want because I
cant remember the module number. Any ideas???

Thanks
 #2  
12-15-05, 10:35 PM
Jim Rech
To rename the active module just open the Properties window (press F4) and
change its name there.
 #3  
12-15-05, 10:37 PM
Bob Phillips
For what? Whether to do it? Yes! What to call them? Only you know what they
do. Too many? Probably. Too much code? If you have 60 very big modules,
probably. If 60 with very little code in each, probably better to group some
of them.
 #4  
12-15-05, 11:34 PM
Jim Thomlinson
60 is a lot of modules. I am not saying it is wrong just that it is a lot...
You should consider grouping some of the code as Bob suggested. You can
change the module names a Jim suggests, the only caveat bieng if in any of
your module you have explicitly reference one of the other modules then you
will need to manually chage the reference. For example if in module 2 you
called a sub from module 1 like this Call Module1.Mysub() then you have to
manually change this lien of code to reflect the new name you have given the
module. Finally just for consistency it is standard practice to start all of
your module names with either mod or m such as

modFileFunctions or mFileFunctions
Similar Threads
Changing module names

Is it possible to change the name of the CRM modules? For example: Sales -> Fundraising Marketing -> Campaigns Service -> Events Gavin

Changing the module not taking effect in calling module

Hi, I've a module report.py having a set of funtions to open/close/write data to a log file. I invoke these functions from another module script.py. Whenever I'm changing...

Changing Query Names and Table Names

1)If I change a name for a table, will I break all queries that run against this table? 2)If I cange a query name, will I screw up other queries that use the query whose name...

Changing VB Component Names to match Worksheet names using VBE

Hi, In VBE the worksheets can be identified using a name that never changes (default Sheet1 etc) To retrieve that name I can do...

Changing Divsion Names or Locations Names

How do you add a site to the Division or location area. Also, can you rename Division or add your on there?


All times are GMT. The time now is 12:40 PM. | Privacy Policy