Skip to main content

XlColumnDataType enumeration

Specifies how a column is to be parsed.

Name Value Description
xlDMYFormat 4 DMY date format.
xlDYMFormat 7 DYM date format.
xlEMDFormat 10 EMD date format.
xlGeneralFormat 1 General.
xlMDYFormat 3 MDY date format.
xlMYDFormat 6 MYD date format.
xlSkipColumn 9 Column is not parsed.
xlTextFormat 2 Text.
xlYDMFormat 8 YDM date format.
xlYMDFormat 5 YMD date format.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>