Excel/VBA Date Format Problems
Posted on 2011-02-21
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
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