Francesco,
You say this is CSV file. "C" stands for comma. Then you say the delimiter
is ";". If so, of course Excel will not find the fields, as there is only 1
field per row.
Use a comma as the delimiter, or do not call your files csv.
Hope that helps
NickHK
"kekkonen" wrote in message
om...
NickHK,
Excel recognizes my file as CSV file but since it was UNICODE encoded,
Excel failes to find the column separator (semicolon in my case) while
it's parsing the file.
P.S.: it seems to me that the code you wrote in your post is written
in VB (or VBScript?) and it seems that the instruction specifies
directly the file format.
In C++ I cannot do that, I can only write my data values formatting
them to be csv compliant.
Thanks and regards,
Francesco
"NickHK" wrote in message
...
Francesco,
Why not let Excel do it for you:
WB.SaveAs Filename:=strFileName", FileFormat:=xlCSV
NickHK