Saving CSV files in Excel macros

  • Thread starter Thread starter bslater
  • Start date Start date
B

bslater

I have a macro that pulls data from a SQL database,
formats it, and saves it into csv files. This macro has
worked perfectly for 7 months but recently the formatting
has stopped saving to the csv files. The date formats
specifically are not saving. If I leave the csv file open
and manually save it, the date formats save as normal.
Why would a manual save correctly save date formats but
the save function does not?

Thanks!
 
some things, if touched by VBA, seem to adopt either a US centric format or
(less often) a regional version format.

Have you changed versions of Excel recently? I believe the effect differs
by version, with later versions being gradually more international aware.
 
Thanks for replying Tom. As for my excel version, it is very possible
that the version has changed, but I wouldn't know. My company has a
knack for changing things without letting anyone know. My current
excel version is 9.0.4402 SR-1 (excel 2000). If this is indeed what
is occuring, how would I go about bypassing VBA's adoption of the
different formats?

Thanks!

Brian
 
Back
Top