Alan Bourke wrote:
> On Fri, 29 May 2009 10:35 -0500, "Stephen Russell"
> <[email protected]> wrote:
>
>
>> Why not open the sheet in VFP and set your date's language after the
>> fact?
>>
>
> It doesn't work. 20th May 2009 goes in as:
>
> 05/20/2009
>
> whereas I need:
>
> 20/05/2009
>
> Even highlighting the column in Excel, making it a date and setting the
> format to dd/mm/yyyy doesn't change it.
>
Hi Alan, sorry if I'm late for this.
This is what works for me :
.
..
...
oExcel.ActiveSheet.Range('a2').Offset(1,0).CopyFromRecordSet(loRecordSet)
endif
loRecordSet.Close()
endif
for lnx = 1 to fcount(lpEntrada)
if inlist(type(field(lnx, lpEntrada)), 'D', 'T')
oExcel.ActiveSheet.Columns(lnx).NumberFormat = "m/d/yyyy"
else
oExcel.ActiveSheet.Columns(lnx).NumberFormat = "General"
endif
endfor
endfor
...
..
.
HTH
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
