K
K
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,WorksheetNumber).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
* 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,WorksheetNumber).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