Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
2 Excel Automation Questions....Date & Win98
Message
From
28/05/2002 10:35:12
N. Lea
Nic Cross Enterprises
Valencia, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
2 Excel Automation Questions....Date & Win98
Miscellaneous
Thread ID:
00662013
Message ID:
00662013
Views:
47
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.
Next
Reply
Map
View

Click here to load this message in the networking platform