Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dates NumberFormat problem
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01379313
Message ID:
01379339
Views:
23
>>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 && Oddly Using TYPE XL5 produces the file in the upper case
	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
Previous
Reply
Map
View

Click here to load this message in the networking platform