Suggestions on Organizing VB procedures

[Guest]

I have been adding VB procedures to my PERSONAL.XLS files, but now that file
has become so full of modules that it is hard to locate the procedures. I
would be interested in suggestions on best practices to organize VB
procedures. Do you keep all of your procedures in the personal.xls file? do
you use multiple personal.xls files in the start up folder?

Thank you!

 

[Guest]

Hi Filo

im using add-ins with difrent's categories and load them as needed

just a surgestion


"Filo" skrev:

 

[Guest]

hi,
you should only put the macro's you use in your personal file. if you have
so many that you are loosing them then you have way too many.
suggestion: create a file and put your excess in that file. on sheet one,
create an index with a discription and module number. if these macro are
seldom used then you can open this file when needed.
i once did this when i was managing some 40+ xl files that had macros. also
we had a access database linked to our sql server. we wrote special access
queries and downloaded data via microsoft query from the server. we had a xl
file which listed filename, access query, what the xl file did, who requested
it, ect. worked pretty good.
regards
FSt1

 

[Bob Phillips]

It is not necessary for all macros to be in separate modules. Group them
into functional categories, and have the groups in separate modules.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)