Managing Modules/Macros - More than one Module FOLDER?

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

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" <excel_hariNOSPAM@hotSPAREMEmail.com> wrote in message
news:Odg22bWfFHA.572@TK2MSFTNGP15.phx.gbl...
> 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
>
>

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.).

--
HTH

Bob Phillips

"Hari Prasadh" <excel_hariNOSPAM@hotSPAREMEmail.com> wrote in message
news:Odg22bWfFHA.572@TK2MSFTNGP15.phx.gbl...
> 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
>
>

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


"Bob Phillips" <phillips@tiscali.co.uk> wrote in message
news:O5%239j1WfFHA.484@TK2MSFTNGP14.phx.gbl...
>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.).
>
> --
> HTH
>
> Bob Phillips
>
> "Hari Prasadh" <excel_hariNOSPAM@hotSPAREMEmail.com> wrote in message
> news:Odg22bWfFHA.572@TK2MSFTNGP15.phx.gbl...
>> 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
>>
>>
>
>