et the dates
in the right format.
does that help?
do you need more help?
Paul
- Original Message
> From: Andy
> To: MS EXCEL AND VBA MACROS
> Sent: Fri, November 5, 2010 9:16:40 AM
> Subject: $$Excel-Macros$$ Date confusion when copying from CSV to Excel
>
> Hey there
Hey there.
This problem is giving me a major headache and no post I have read can
seem to help with the problem I am having.
I have some code to copy any present data from CSV files to a main
workbook (basebook) but some seem to paste over as mm/dd/yy instead of
dd/mm/yy...
Two of the CSV's that