98.9% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Paste in CSV file
Resolved · Medium Priority · Version 2007
Tom has attended:
Excel VBA Intro Intermediate course
Paste in CSV file
I have code which opens up a CSV file, copies it and pastes it into my Excel file. Within the CSV file there are dates in the format 01/06/2011 which dislays as Jun-11. However when i look at what has been pasted in it shows up as 11/01/2011. This is not correct. the code i have is as follows:-
Dim filName As String
ChDir "C:\Users\tlittle\Documents\Brent Settlement Analysis\May11 Front Month 2 Mins"
filName = Application.GetOpenFilename(FileFilter:="csv files,*.csv", Title:="Select Settlement File", _
Workbooks.OpenText Filename:=filName, DataType:=xlDelimited, comma:=True, Local:=True
'If Err.Number = 1004 Then
'MsgBox ("Please Choose Settlement File")
Application.DisplayAlerts = False
Application.DisplayAlerts = True
ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
I have put i break in the code to see if it open and copies in the correct date format which is it does. Any help you can provide is greatly appreciated.
For upcoming training course dates see: Pricing & availability
RE: Paste in CSV file
Thanks for the question
Sorry for the delay in responding. This will require a little research and I will endeavour to get you a full response by the end of today or tomorrow morning
Data is th key to a good database, therefore checking is essential.
London & UK
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.