It seems to me that if the dates in the Access generated CSV were formatted
in m/d/yyyy format you wouldn't run into the problem. Excel would translate
the date-like text into actual Excel dates, then you wouldn't need any kind
of macro.
Is there a reason that can't be done?
Regards,
Ron
|