VFP Automation Row Insertion Issue

[whornak]

I am attempting to populate several columns in a single row but I can't get the values to seperate and appear in there respective columns. How do I insert a string into a row and avoid inserting all the data into each column.

I am writing the code in VFP 8.0 which is shown below.

xlSheet.Rows("14").Value = lcRowData

where lcRowData is:
'01/02/03','63032-021-15','LUXIQ FOAM 0.12% 15G','A2D016'

I tried several variations of delimited and seperated values, such as:
quote delimited comma seperated
quote delimited tab seperated

But nothing works.

Thanks in advance for any assitance.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?d2hvcm5haw==?=,

I was hoping an Excel person would happen by... In the UI, you'd dump the data into a
cell, then use Data/TextToColumns, which gives this

Selection.TextToColumns Destination:=Range("A9"), DataType:=xlDelimited, _
TextQualifier:=xlSingleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1)),
TrailingMinusNumbers:= _
True

If you have access to ADO, it might be more efficient to put the data into an ADO
recordset, then use the CopyFromRecordset method.

You might also try asking in excel.programming

I am attempting to populate several columns in a single row but I can't get the values

to seperate and appear in there respective columns. How do I insert a string into a row
and avoid inserting all the data into each column.

I am writing the code in VFP 8.0 which is shown below.

xlSheet.Rows("14").Value = lcRowData

where lcRowData is:
'01/02/03','63032-021-15','LUXIQ FOAM 0.12% 15G','A2D016'

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail