Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem inserting date into Excel Sreadsheet
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00809556
Message ID:
00809573
Vues:
33
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform