Alan Bourke wrote:
> I'm automating Excel with VFP9, using ADO to populate rows in a
> spreadsheet,as detailed here:
> http://fox.wikis.com/wc.dll?Wiki~ExcelAutomation~VFP
>
> Which all fine apart from the usual - bloody dates, or more specifically
> datetimes. I'm running a SELECT on a VFP table similar to this:
>
> VFP2Excel(_samples+'data\testdata.dbc','select * from
> employee',.ActiveSheet.Range('A10'))
>
> One of the VFP fields is DateTime, but it was going into Excel in US
> format, i.e. month first. Nothing I could do with cell formats, custom
> or otherwise, would change it. I can't see anything in the ADO
> documentation about regionalisation.
>
> So I gave up and decided to put the date part in one column and the time
> in another. But this *still* puts the date in with the wrong format.
>
> Has anyone who doesn't work with US-format dates ever done this ?
>
>
>
>
Alan,
Excel displays data according to the options in the windows regional
settings, check that and change to English (United Kingdom) or whatever
other regional setting you want.
Another option is to format the cells with data:
Suppose the data is in column C:
Columns("C:C").Select
Selection.NumberFormat = "dd/mm/yyyy"
HTH
Jaime Vasquez.
_______________________________________________
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.
