>Excel recognises delimiters for cell columns and for a new line, >so: > >_CLIPTEXT = "One" + CHR(9) + "1" + CHR(13) + "Two" + CHR(9) + "2" >oXL.Range("B2").Select >oXL.ActiveSheet.Paste > >Would put "One","1","Two","2" in B2,C2,B3,C3 respectively. > >Ian. > > > >>I'm can't recall the specifics, but I recall a discussion that copying the data to the clipboard using _cliptext and paste while in Excel. >> >>PF >> >>>I have been working on updating an Excel spreadsheet with data from VFP 6. I can do all of the basic processes, but the way I am updating is very slow. I am currently using oleapp.range("A1").value=somevalue then oleapp.range("A2").value=anothervalue and so on. Some of these processes involve a large amount of data. Is there a way to select a range of cells and update them all from an array or other source that would improve the performance? >>> >>>Thanks in advance for any suggestions.
