+ Reply to Thread
Results 1 to 7 of 7

which is more efficient? less macros in more modules VS more macros in less modules?

  1. #1
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    which is more efficient? less macros in more modules VS more macros in less modules?

    Hi
    I have a question of efficiency regards macros. I tried to Google it but I didn't get a clear answer.

    Which would be more efficient.
    10x macros all saved in 1x module
    VS
    10x macros saved in different modules i.e. there would be 10 modules


    Which is more efficient way (less time consuming) to run macros? That is if there is any difference at all.


    Cheers
    Rain
    Last edited by rain4u; 04-19-2011 at 08:21 PM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: which is more efficient? less macros in more modules VS more macros in less modul

    There should be no substantive difference at all. The reason for more modules would be ease of organization. Finding one macro in 100 all in one module could get cumbersome, or not. It's pure opinion.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Re: which is more efficient? less macros in more modules VS more macros in less modul

    Good to know as I prefer to have more modules and keep respective macros for certain tasks in specific modules

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: which is more efficient? less macros in more modules VS more macros in less modul

    It would depend what's in them and how they get called, but I doubt you would notice much difference.
    Remember what the dormouse said
    Feed your head

  5. #5
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Re: which is more efficient? less macros in more modules VS more macros in less modul

    What to you mean it depends how they are called?


    Cheers
    Rain

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: which is more efficient? less macros in more modules VS more macros in less modul

    Let's say you had 10 modules with 4 routines in each. If your code calls one routine from each module, then all the modules have to be loaded and compiled. On the other hand, if you have all 10 in the same module, only 1 module has to be loaded. I doubt you would notice the difference in reality though.

  7. #7
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Re: which is more efficient? less macros in more modules VS more macros in less modul

    Aha. Something to bear in mind.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1