Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Better way to code Excel automation?
Message
From
29/04/2008 11:42:51
 
 
To
29/04/2008 10:29:54
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01313820
Message ID:
01313886
Views:
18
Is there a more maintainable way to code VFP automation of Excel other than "dead reckoning" of cells e.g.

What I generally do is to create a cursor that has the same layout required by the spreadsheet and the push the data over to Excel using _VFP.DataToClip() and then use the Worsheet's paste() method to paste the data into the sheet.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform