convert to csv using macro gives wrong seperator

[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?

 

[Jim Rech]

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?
|
|

 

[patrick goovaerts]

Thanks!