Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem inserting date into Excel Sreadsheet
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00809556
Message ID:
00809573
Views:
35
>Gregory
>
>VFP is set to British Date as is regional setting in control panel. Can I use your code in conjunction with mine? If so how?
>
>Colin

Colin,

this works over here. Does it over there ?
create cursor test ( d1 c(20) )
insert into test values('=date(2002,1,1)')
insert into test values('=date(2002,1,4)')
insert into test values('=date(2002,4,1)')
go top
_VFP.DataToClip(,,3)
&& activate excel
&& paste, got this after formatting dd MMM yyyy
D1                  
01 Jan 2002
04 Jan 2002
01 Apr 2002
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform