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