<div>
What are the date formats in the CSV file?
</div>


What are the date formats in the CSV file?

<div>
<div class="content wysiwyg-content">
I am currently attempting to open a CSV file using VBA however when the CSV file is opened using the following code....<br />
<br />
&nbsp; &nbsp; CSVFile = Application.GetOpenFilenam<wbr />e(&quot;&quot;, , &quot;CSV Import File&quot;)<br />
&nbsp; &nbsp; Application.DefaultFilePat<wbr />h = origDefPath<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; If CSVFile = &quot;&quot;&nbsp;Then<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Else<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Set SageWorkbook = Application.Workbooks.Open<wbr />(CSVFile)<br />
<br />
One column contains invoice date information and on certain rows the date format is alterting to MM-DD-YYYY while other remain DD-MM-YYYY. &nbsp;If I open the file manually the dates are fine.<br />
<br />
Please can anyone advise
</div>
</div>


I am currently attempting to open a CSV file using VBA however when the CSV file is opened using the following code....

    CSVFile = Application.GetOpenFilename("", , "CSV Import File")
    Application.DefaultFilePath = origDefPath
    
    If CSVFile = "" Then
    
    Else
    
    Set SageWorkbook = Application.Workbooks.Open(CSVFile)

One column contains invoice date information and on certain rows the date format is alterting to MM-DD-YYYY while other remain DD-MM-YYYY.  If I open the file manually the dates are fine.

Please can anyone advise

Excel/VBA Date Format Problems

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.