Date formats incorrect with CSV files

M

Mark

Currently when I open a CSV file with date "05/08" it
comes up as "5-AUG" when I open the file from Excel. If I
open the file from VBA code using workbooks.open into
excel the date comes up as "8-MAY" any ideas of how to
open the file in VBA code and return the correct format
of "5-AUG"

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem formatting dates from CSV file 2
Adding data to MS Access from csv file 0
Date reformatting question 5
Getting Radio Buttons to work, that are inserted via AutoText 0
Dates format 2
Paragraph numbering in Word 1
Excel CSV Files; Creating Of 3
Date format error with CSV file 6

Top