I currently us a 4D array to mirror an Excel database consisting of

* folder,
* workbook (with one worksheet),
* rows and columns


Private Type MasterArray
FolderNumber as Integer 'This is a number representing the
folder name
WorkBookNumber as Integer This is a number representing the
workbook.worksheet
Values as Variant 'Values (r,c) are the row
and column numbers on the worksheet
End Type

Dim mMasterArray ( ) as MasterArray

mMasterArray (FolderNumber,WorkBookNumber). Values (r,c)

I want to now extend this to a 5D array , so I can add one more
dimension to accommodate different worksheets in a workbook.

I have two questions.


1. Do I just add WorksheetNumber as Integer to the above type list ,
resulting in
mMasterArray(FolderNumber,WorkBookNumber,Worksheet Number).Values (x,y)

2. Instead of numbers can I just define FolderName as String, and use a
name instead of a number as the reference.


Thank you very much for any ideas

K