Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date Fields incorrect format after CopyTo into Excel
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00708405
Message ID:
00708492
Views:
9
Well Michael, it sounds like your Excel's default way of looking at the date is
15-october-02.

You might try to:
1) Set up your default data types in excel before you copy over Format...Cells...Number page... Date

2) You Could automate the entire process. This way you have control of every cell and every row.
you could check out the book from Hentenwerke called
Microsoft Office Automation with VFP
. Very Good Book!!!! It might take a little work, but you have more control.

HTH
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide

LeRoy Jackson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform