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
"Patrick Goovaerts" <(E-Mail Removed)> wrote in message
news:47021258$0$22314$(E-Mail Removed)...
| 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?
|
|

Thanks!

"Jim Rech" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> 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
> "Patrick Goovaerts" <(E-Mail Removed)> wrote in message
> news:47021258$0$22314$(E-Mail Removed)...
> | 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?
> |
> |
>
>