Re: $$Excel-Macros$$ Date confusion when copying from CSV to Excel

2010-11-05 Thread Paul Schreiner
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

$$Excel-Macros$$ Date confusion when copying from CSV to Excel

2010-11-05 Thread Andy
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