convert to csv using macro gives wrong seperator

  • Thread starter Thread starter Patrick Goovaerts
  • Start date Start date
P

Patrick Goovaerts

Hi,

We used to store excel data to a CSV file on our server to be pickup by
another program. This is always done with a macro which simply executes a
save-to-csv.

Since installing Office2007, this macro writes this CSV file with a wrong
delimeter. The file is generated with a ',' in stead of a ';' (which is
defined). When we save the document as CSV without the macro (manual
process) the file is correctly written...

any suggestions?
 
Try using the "Local" parameter in your macro (I assume you're using the
SaveAs method):

ActiveWorkbook.SaveAs Filename:="C:\Book1.csv", FileFormat:=xlCSV,
Local:=True

--
Jim
| Hi,
|
| We used to store excel data to a CSV file on our server to be pickup by
| another program. This is always done with a macro which simply executes a
| save-to-csv.
|
| Since installing Office2007, this macro writes this CSV file with a wrong
| delimeter. The file is generated with a ',' in stead of a ';' (which is
| defined). When we save the document as CSV without the macro (manual
| process) the file is correctly written...
|
| any suggestions?
|
|
 
Back
Top