Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Excel
Miscellaneous
Thread ID:
00742216
Message ID:
00742225
Views:
18
>How can I add graphics, format fields or take real advantage of the excel power when exporting from VFP?
>I aslo have a table with more than 38000. When I use the cpy to functions it exports only 16384 records. Why?

If you go to search and type "oExcel" you will get a list of messages that demonstrate some of the stuff others are doing.

If you're just getting started with automation, read Hilmars:
http://www.levelextreme.com/Magazine/September2002/Page45.asp

VFP 7 Help has some automation tips. It sounds like you need to use Excel Automation because the COPY TO ... XLS will not transfer all the data. Start with Hilmar's article. Then we can move on to some of the specific stuff you need to do.

Most of us use the Excel macro recorder and (in most cases) paste the code we need into our VFP programs.

HTH
Imagination is more important than knowledge
Previous
Reply
Map
View

Click here to load this message in the networking platform