Managing Modules/Macros - More than one Module FOLDER?

[Hari Prasadh]

Hi,

What am I asking might be ridiculous considering that am not even a day to
day user of Macros.

I copy codes which I ask/get/need from NG's and web-sites etc for my
personal macro workbook (or any heavy macro workbook).

Presently all these macro/modules are branches of a single tree under Module
folder.

Is it possible to have more than one Module FOLDER?

Within the Modules I have more than a handful of macros. Many of them could
ideally be grouped in to categories (let's say depending on the kind of
need/situation). Like lets say I have 8 macros for preparing report 1 for
Client 1. For, report 2 and for the same Client 1 I could be using some
other 4 macros and so on.

Just the way that we create more than module using Insert - Module is there
a solution for this?

How does veterans/inveterate users/developers of modules manage their
project explorer?

(Oh! yes, though you would have guessed by this time, still.... I dont use
Class module folder - still not comfortable - though I have read one very
good tutorial on the same by J Peltier in some site)


Thanks a lot,
Hari
India

 

[Bob Phillips]

I am not absolutely sure, but I think you are asking if we can have a
hierarchy of modules. If so the answer is no. If you are just saying can you
have many modules, then yes.

I think that you will find though that all serious VBA users will have many
modules within their projects, and will tend to group their code within
those modules by function (printing procedures, formatting procedures
etc.), and/or by requirement (anything to do with report 1, report 2, etc.).

 

[Anne Troy]

Hello, Hari. I believe most developers will tell you to put "like" macros
into one module; i.e., using the modules as "folders".
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Hari Prasadh]

Hi Bob and Anne,

Yes, I wanted a hierarchy of modules , just like the way we manage folders
etc in Windows.

Problem with having many macros in a single module is that one has to
scroll, scroll and scroll and VB edit is not very convenient for that (dunno
about otters)

Also as per me having a hierarchy of modules would give even more control or
facility in arranging my stuff.

Anyway, thanks a lot for your replies.

Thanks a lot,
Hari
India