View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Managing Modules/Macros - More than one Module FOLDER?

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" wrote in message
...
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