>Cetin
>
>I changed machines and its working. How now do I populate the spreadsheet with data from VFP code?
>
>Thanks a lot so far - you have great patience!
>
>Colin
Glad :)
Populating the spreadsheets could be done in many ways. For small amount of data (and within 65536 recs sheet limit) you could simply do :
lcTempFile = sys(2015)+".txt"
copy to (lcTempFile) delimited with TAB
_cliptext = filetostr(lcTempFile)
erase (lcTempFile)
oExcel.ActiveWorkBook.ActiveSheet.Range("A1").PasteSpecial()
_Cliptext = ""
Cetin