>>You're right, type XL5 produces the dates in the correct format. Type XLS however, produces them in the wrong format and I have not find a way to correct the format.
>>
>>However, XL5 have the problem of wrong name casing for the file. I guess I need to use XL5 and then rename the file to correct casing using MoveFile API.
>>
>>Net v zhizni sovershenstva (don't know how to translate).
>
>Yes, it is not a perfect word (and in addition, it is MS word, then however we always have workaround). See my reply to your previous message regarding XLS formatting
Ok, this code
COPY TO (m.tcXLSFileName) TYPE XL5
MoveFile(m.tcXLSFileName, m.tcXLSFileName)
seems to take care of the Dates formatting problem.
Thanks again.
If it's not broken, fix it until it is.
My Blog