Passing an array into multiple Modules

**jo15765** · 11-13-2011, 01:17 AM

I have 5 arrays (one for Mon - Fri) that I have been re-writing for 3 different modules that are called at 3 different times a day. For example, on Monday Module_1 has the Array written out, Module_2 has the same Array written out, and Module_3 has the same array written out...

My question is...since it is the same Array being called 3 different times a day, is there a way to declare the Array once, and then call it from Module_1, Module_2, and Module_3? Would cut down on code writing TREMENDOUSLY!!!!

Actually I thought of one difference in the Arrays.....In Module_1 the workbooks are called like this "Test1.xls" whereas in Module_2 and Module_3 they are only called with "Test"...that may throw a monkey wrench into anything...Idk, but help is appreciated

**MarvinP** · 11-13-2011, 01:56 AM

Hi jo15766,

You need to Dim your variables as global. Read about Project and Global Scope on:
http://www.cpearson.com/Excel/Scope.aspx

**jo15765** · 11-13-2011, 02:18 AM

So if I understand this correctly I could declare my Array as

Global Array = Array_Monday_1("Test.xls", "Test1.xls")

And I could set it:

Global Function Declare_Arrays()
Global Array = Array_Monday_1("Test.xls", "Test1.xls")
Global Array = Array_Monday_2("Test", "Test1")

Then to actually call the Array from within the module, I would use:

    Dim varBooks
    Dim varbook
    Dim wb As Excel.Workbook

    varBooks = Array_Monday_1

Do I have a grasp on that?

Passing an array into multiple Modules

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Passing an array into multiple Modules

Re: Passing an array into multiple Modules

Re: Passing an array into multiple Modules

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions