Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
2 Excel Automation Questions....Date & Win98
Message
De
28/05/2002 10:35:12
N. Lea
Nic Cross Enterprises
Valencia, Californie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
2 Excel Automation Questions....Date & Win98
Divers
Thread ID:
00662013
Message ID:
00662013
Vues:
48
Good morning! I have two questions that I have been trying to go over this past weekend. I remember seeing the question about the date somewhere, but I cannot seem to find it. Hopefully, someone here will be able to help me out.

1) When using automation to bring over data from an XL5 file (from Excel XP to VF7), the dates come over as character opposed to the date format. I remember somewhere that states VF transforms the date into character via a particular process. It does some mathmatical computation, which I do not remember. It had to do with a particular date and also divded by 364 or something like that. Can anyone help with this problem?

2) I created an excel automation process in Windows XP Pro Environment using VF7. However, when I attempt to run it on a Windows 98 environment, it fails to work. I installed VF7 on the 98 machine, in hopes that I would discover something with it. When I looked up the Excel Constants in the Object Browser, I could not find the ones for Excel. I thought they were not there, so I manually brought it over to the Object Brower window. The process still did not work. Any suggestions as to why the automation would not work? It returns a fatal exception error (no BSOD), but a OLE Fatal Error. Thanks for any insight on this matter.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform