Excel opening CSV files via Macro wrong 1

[TheLad]

Guys

I am opening a CSV file from an Excel macro and the format of the date (stored in column A) keeps getting messed up. Column A has the date in as per the contents of the CSV file but from Row 13 onwards, the format of the cell changes from Date to General.

Now if I open the CSV file normally in Excel (File / Open etc...), the CSV file opens perfectly, the contents of Column A are all formatted to Date, and I do not have any of the date formatting issues.

I recorded the process and pasted that into my Macro but it still shows the symptoms described above when opened as part of the Macro code. There is nothing in the CSV file that would cause this behaviour

Does anyone have any ideas please?

--------------------------------------
"Insert funny comment in here!"
--------------------------------------

 

[PHV]

Any chance you could post some relevant info like, say, your actual code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Hi,

"the format of the cell changes from Date to General."

A .csv file has NO FORMAT. It is merely a TEXT file.

Rather than using Workbooks.Open..., use Data > Import External Data > IMPORT and in the Import Wizard, you can explicity specify how you want your file parsed. Once you get it to work, use your macro recorder.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TheLad]

Thanks SkipVought for your (non sarcastic sounding) answer, that is exactly what I needed

--------------------------------------
"Insert funny comment in here!"
--------------------------------------

 

[remeng]

TheLad,

Let me know if you need any help with this further. I have made some macros to handle .csv files importation.

 

[TheLad]

Thanks for the offer, I think I am ok for now as the CSV file is now importing ok and I can manipulate it as I like.

--------------------------------------
"Insert funny comment in here!"
--------------------------------------