ModelTableColumns DataType

[wsnyder]

Hi all,

I'm trying to get the Data Type for each Column in the Data Model

I'm getting a list of numbers, but I cannot find any documentation as to what each number means:

wsnew.Cells(j, 3).Value = dmt.ModelTableColumns(x).DataType

Here are the numbers returned:

• 5
• 6
• 7
• 20
• 130

Thanks,
w

 

[RoryA]

5 = Decimal number
6 = Currency
7 = Date
20 = Whole Number
130 = Text