How do YOU organize the Excel projects?

  • Thread starter Thread starter art
  • Start date Start date
A

art

I am not a pro in the programming, but I wrote several macros/programs doing
various stuff over the years. Some of the rutines I use for future
reference. All of them are in the Module1, Module2.....Module35.
If I want to find some of the projects I have to go through 30 modules to
find the right one.
How do pros take care of it?
Thanks.
Artur.
 
Hello art,

Try renaming the module with something that could give you an idea on what
it contains. You can set this in the properties window (View|Properties
window or F4). Select the module in the project explorer then change the
name that appear in the Properties window

I am not a pro neither but I hope this suggestion might help.

Jon-jon
 
As long as you know the name, which assuming it has a reasonably descriptive one, you can get
simply by scrolling the list from Tools / Macro / Macros, then you can switch into the VBE and
simply do a search on the entire project as opposed to limiting it to just one module.

Within the VBE:- Edit / Find / Put in search parameter & Check the 'Current Project' option.

Agree with Conrado though, I like to name the modules themselves with something descriptive and
group similar routines together inside.
 
When in the visual basic editor, you should have the
project panel on the left that lists your modules. Below
that panel is the properties panel. If you click on a
module name in the project panel, it will bring up the
properties panel for that module. You can then change
the name of that module in the properties panel from
Module1 to something more descriptive of what that module
does.
 
I'm not sure whether this utility will help you or not, but Rob Bovey
offers 'Code Documentor' for free. I found this after I had already
written a routine that dumps into a text file a listing of what
procedures are in each module along with a description of each
procedure.

http://www.appspro.com/

HTH
Paul
 
The Pros do often have the MS Office Developer Edition. In
this 2000 edition, there is a special database program to
store and organize all your code snippets, functions or
modules. It is named The "Code Librarian" and is a
fantastic tool. You can also give each module, function or
code snippet their own key words which makes it easier to
search for the right code.

That is what the pros do, but you might want to make your
own system in an Excel Workbook or and Addin? However, as
mentioned by others, good naming and keywords are
essential for finding your code fast an easy.

Best wishes
Jan
 
Back
Top