Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 to Excel
Message
From
12/07/2000 18:59:56
Todd Cottengim
Alpine Land Information Services
Redding, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
VFP6 to Excel
Miscellaneous
Thread ID:
00391588
Message ID:
00391588
Views:
36
We are starting to directly write file to Excel using a variety of VBA commands that also work in VFP. Unfortunatly, The only way we have found to change the value of a cell is by Value property of a cell. This is ok if the data we are trying ot send to Excel is a small range but when there are 40 columns and 200 rows of data, changing the value of 8000 cells can take some time. Is there a way to "drop" an array into a range of cells instead of chaning the values one by one?

My programming partner and myself are a couple of self-taught programmers and appreciate any help offered.

Todd Cottengim
Alpine Land Information Services
tcottengim@alpine-lis.com
Next
Reply
Map
View

Click here to load this message in the networking platform