Re: [Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-28 Thread Erich Neuwirth
Regards, Christian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ] On Behalf Of Erich Neuwirth Sent: Thursday, April 24, 2008 18:23 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] PutArrayFromVBA: numeric vs string This is an array with mixed

RE: [Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-28 Thread Christian Prinoth
al Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Thursday, April 24, 2008 18:23 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] PutArrayFromVBA: numeric vs string This is an array with mixed data types. This is difficult to h

Re: [Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-24 Thread Erich Neuwirth
ntains a Null value. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Thursday, April 24, 2008 17:22 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] PutArrayFromVBA: numeric vs string Handling missing values can b

RE: [Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-24 Thread Christian Prinoth
& ")" End If End Sub Which is not very elegant... Btw, the function StringArray crashes if the array contains a Null value. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Thursday, April 24, 2008 17:22 To: R (D)COM and RExce

Re: [Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-24 Thread Erich Neuwirth
Handling missing values can be controlled when transferring data from Excel sheets to R. It is not implemented in detail when transferring data from VBA to R. Where does makearr come from anyway? It is neither a VBA function vor a function from RExcel. Christian Prinoth wrote: I often use the