Class ModelFormatDate (Excel VBA)

The class ModelFormatDate represents the format to be used for a model measure in the data model.


To use a ModelFormatDate class variable it first needs to be instantiated, for example

Dim mfd as ModelFormatDate
Set mfd = ActiveWorkbook.Model.ModelFormatDate

ModelFormatDate class variables can be set using the Model.ModelFormatDate procedure.


Specifies the date format, for example, "dd/mm/yy".

ActiveWorkbook.Model.ModelFormatDate.FormatString =